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