VLOOKUP for text

[juan jimenez]

hi,

i imagine it should be very easy but i am trying to do a vlookup for 2 columns with text and it does not work!!

i have tried using number format and text format with no difference.

Can anyone help?

[#2 · Accepted solution]

@juan jimenez 

Juan, VLOOKUP works from left to right, you need to move returned array into column D

Or better use XLOOKUP or INDEX/MATCH

[#3]

@juan jimenez 

If you must keep things as they are:

=VLOOKUP(C4,CHOOSE({1,2},'Hoja1 (2)'!$C$1:$C$7,'Hoja1 (2)'!$B$1:$B$7),2,0)

I still think @Sergei Baklan 's XLOOKUP recommendation is the way to go, if you have access to the function.