Nov 23 2021 09:13 AM
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
Nov 23 2021 09:25 AM
=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.