Forum Discussion
Solved
A BASIC VLOOKUP PROBLEM
VLOOKUP doesnt work at B1(sheet3) in attached example For example If I write a letter and word combination like 4KK, the formula works but it doenst work with just a number like 760 I trie...
Here you are:
=IFERROR(VLOOKUP(A1*1,Sheet1!$A$1:$B$190,2,0),VLOOKUP(TEXT(A1,"0"),Sheet1!$A$1:$B$190,2,0))
You're covered for numbers and text.
Here you are:
=IFERROR(VLOOKUP(A1*1,Sheet1!$A$1:$B$190,2,0),VLOOKUP(TEXT(A1,"0"),Sheet1!$A$1:$B$190,2,0))
You're covered for numbers and text.