New Contributor

# 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

# Re: Vlookup -

=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.

# Re: Vlookup -

Thank you. So simple..

LB