Vlookup -

Copper Contributor

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

@Leigh_Barker 

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

@OliverScheurich 

 

Thank you. So simple..

 

LB