Vlookup -

Copper Contributor


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 ??





2 Replies




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.



Thank you. So simple..