Forum Discussion
Solved
Excel Vlookup Error
Hey, I am using excel 2007, and having a problem while performing Vlookup in my demo data, I am trying to find ProductId via ModelNumber, And when I am applying Vlookup to that value means on Model ...
=INDEX($B$2:$B$8,MATCH(E2,$C$2:$C$8,0))You can do this with INDEX and MATCH.
=VLOOKUP(E2,CHOOSE({1,2},$C$2:$C$8,$B$2:$B$8),2,0)This is the alternative with VLOOKUP. Enter this formula with ctrl+shift+enter if you don't work with Office365 or 2021.
If you work with Office365 or 2021 you can use XLOOKUP.
Formula I used in F2 Cell :- =VLOOKUP(E2,A1:C18,1,FALSE)