Forum Discussion
Solved
Excel 2016 LOOKUP & TEXT cells
hi, can someone help me to undersatand why the lookup formula is not working for this text searchs? Thank you, Juan
VLOOKUP works from left to right. It finds nothing in first column of lookup range (column D) and returns an error.
Alternatively
=IFNA(INDEX($D$3:$D$1646, MATCH(C3,$H$3:$H$1646,0)), "no such")
As SergeiBaklan says, the lookup table is not conveniently arranged for VLOOKUP. INDEX/MATCH is more general but, if you wish to use VLOOKUP, it is possible to play tricks to build an array that works with the function.
= VLOOKUP(Appel,
IF({1,0},Apellidos,Nombre),
2,
FALSE)The second line/parameter builds a 2-column array in the correct order.
Nice trick, afraid with decreasing of performance, but that could be not critical on small and medium models.