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. 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 24, 2022

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

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

Resources