May 08 2021 12:55 AM
hi,
can someone help me to undersatand why the lookup formula is not working for this text searchs?
Thank you, Juan
May 08 2021 01:33 AM
SolutionVLOOKUP 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")
May 08 2021 01:44 AM
As @Sergei Baklan 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.
May 08 2021 04:31 AM
May 08 2021 05:08 AM
Nice trick, afraid with decreasing of performance, but that could be not critical on small and medium models.
May 08 2021 05:09 AM
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.
May 08 2021 01:33 AM
SolutionVLOOKUP 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")