Forum Discussion
juan jimenez
May 08, 2021Iron Contributor
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
- May 08, 2021
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")
lonuegbustudentumgc
May 08, 2021Copper Contributor
I need someone to help me with the error message in Anova test
- SergeiBaklanMay 08, 2021Diamond Contributor
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.