英文:
A formula that returns a cell value using the data (number) of a cell in a specific column as the row number in another column
问题
| number data | data | result |
|---|---|---|
| 1 | q | q |
| 4 | w | r |
| 2 | e | w |
| 3 | r | e |
| 5 | t | t |
英文:
| number data | data | result |
|---|---|---|
| 1 | q | q |
| 4 | w | r |
| 2 | e | w |
| 3 | r | e |
| 5 | t | t |
I want to use the number in a cell in column A as the row number in column B and return that value in column C. <br> I was hoping this formula would work. But it failed..
=ARRAYFORMULA(INDEX(A:A,index(B:B)))
答案1
得分: 2
=INDEX(XLOOKUP(A:A,SEQUENCE(ROWS(A:A)),B:B,))
英文:
You can try:
=INDEX(XLOOKUP(A:A,SEQUENCE(ROWS(A:A)),B:B,))
答案2
得分: 2
使用 MAP() 或 BYROW() 函数。尝试 -
=MAP(A2:A6,LAMBDA(x,INDEX(B2:B,x)))
要使输入列具有动态性，可以使用 -
=MAP(A2:INDEX(A2:A,COUNTA(A2:A)),LAMBDA(x,INDEX(B2:B,x)))
英文:
Use MAP() or BYROW() function. Try-
=MAP(A2:A6,LAMBDA(x,INDEX(B2:B,x)))
To make input column dynamic, use-
=MAP(A2:INDEX(A2:A,COUNTA(A2:A)),LAMBDA(x,INDEX(B2:B,x)))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论