Forum Discussion
Solved
Question on a Formula
Say I have the following excel spreadsheet:
| 34 | b62 |
| 6 | z5h2 |
| 10 | |
| 42 | x47 |
| x47 | |
| z5h2 | |
| b62 |
In rows 1-4, items in column A are associated with items in Column B. What formulas would I enter in cells A5 through A9 to get the same entries in Cells A1-A4 above. For example B9 shows the entry b62. What formula would I enter in A9 to replicate 34 which is in Cell A1 where Cell B1 also shows B62.
Thanks
=VLOOKUP(B5,CHOOSE({1,2},$B$1:$B$4,$A$1:$A$4),2,FALSE)
In my spreadsheet i can use above formula.
2 Replies
=VLOOKUP(B5,CHOOSE({1,2},$B$1:$B$4,$A$1:$A$4),2,FALSE)
In my spreadsheet i can use above formula.
