SOLVED

What is the error in the formula of cell A5 of the attached file?

Frequent Contributor

What is the error in the formula of cell A5 of the attached file? I am using the vlookup formula to return the corresponding text of the cell value B5. 

3 Replies
best response confirmed by ajl_ahmed (Frequent Contributor)
Solution

@ajl_ahmed 

=VLOOKUP(B5,CHOOSE({1,2},B7:B76,A7:A76),2,FALSE)

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. An alternative would be INDEX and MATCH. 

@ajl_ahmed If you really do have Excel for O365, you should use XLOOKUP.

=XLOOKUP(B5,B7:B76,A7:A76)

@ajl_ahmed 

One more variant

=IFERROR( INDEX(  A7:A76, MATCH( B5, B7:B76, 0 )), "no such" )

VLOOKUP() always works from left to right, XLOOKUP and INDEX/MATCH are more flexible.