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.
If simple changing of format to "Text" does not work then try this:
On the Data Tools: Use "Text to columns" for column A of Sheet 1. On the third stem make sure that the format of the column is chosen as text. Finish. The formula on sheet3 will be free of errors.
Hope it helps.