Forum Discussion
Vlookup -
Hello,
I cannot figure out why VLOOKUP will not return the data. I tried changing format to text, number, special, etc. It works for some and not others ??
LB
2 Replies
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
In sheet2 in cell A1 the entry was "0001A " with 4 spaces after the value. As the formula looks for an exact match, #NA was returned.
