Excel 2016 LOOKUP & TEXT cells

[juan jimenez]

hi,

can someone help me to undersatand why the lookup formula is not working for this text searchs?

Thank you, Juan

[#2 · Accepted solution]

@juan jimenez 

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")

[#3]

@juan jimenez 

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.

[#4]

I need someone to help me with the error message in Anova test

[#5]

@Peter Bartholomew 

Nice trick, afraid with decreasing of performance, but that could be not critical on small and medium models.

[#6]

@lonuegbustudentumgc 

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.