Forum Discussion
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")
5 Replies
- I need someone to help me with the error message in Anova test
I'd suggest you to start new conversation / thread here and specify more concretely which kind of errors do you have and on which model.
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.
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")
