英文:
Excel: Imputing data when value appears in two columns
问题
我有一个包含四列的电子表格。A列和B列反映了一列唯一的数值。C列和D列反映了一列非唯一的数值。C列中的所有数值都出现在A列中。然而，只有A列中的一些数值出现在C列中。
问题
如何根据截图中显示的情况，从B列中填充正确的数值到D列？
英文:
I have a spreadsheet with four columns. Columns A and B reflect a list of unique values. Columns C and D reflect a list of non-unique values. All values in column C appear in column A. However, only some values in column A appear in column C.
Question
How can I impute the correct values in column D from column B as shown in the screenshot?
答案1
得分: 2
以下是翻译好的部分：
有几种方法可以实现您的结果。尝试其中之一。
=VLOOKUP(C2,$A$2:$B$7,2)
=INDEX($B$2:$B$7,MATCH(C2,$A$2:$A$7,0))
=XLOOKUP(C2,$A$2:$A$7,$B$2:$B$7)
=FILTER($B$2:$B$7,$A$2:$A$7=C2)
对于动态溢出公式-
=BYROW(C2:C11,LAMBDA(x,FILTER(B2:B7,A2:A7=x)))
=XLOOKUP(C2:C11,A2:A7,B2:B7)
英文:
There are few ways to achieve your results. Try one of these.
=VLOOKUP(C2,$A$2:$B$7,2)
=INDEX($B$2:$B$7,MATCH(C2,$A$2:$A$7,0))
=XLOOKUP(C2,$A$2:$A$7,$B$2:$B$7)
=FILTER($B$2:$B$7,$A$2:$A$7=C2)
For dynamic spill formula-
=BYROW(C2:C11,LAMBDA(x,FILTER(B2:B7,A2:A7=x)))
=XLOOKUP(C2:C11,A2:A7,B2:B7)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论