Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Jul 24, 2022
Solved

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

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. 
excel
Formulas and Functions
office 365
  • OliverScheurich's avatar
    OliverScheurich
    Jul 24, 2022

    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. 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 24, 2022

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.

Resources