Vlookup -

%3CLINGO-SUB%20id%3D%22lingo-sub-2998118%22%20slang%3D%22en-US%22%3EVlookup%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2998118%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20cannot%20figure%20out%20why%20VLOOKUP%20will%20not%20return%20the%20data.%20I%20tried%20changing%20format%20to%20text%2C%20number%2C%20special%2C%20etc.%20It%20works%20for%20some%20and%20not%20others%20%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELB%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2998118%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2998232%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2998232%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1227662%22%20target%3D%22_blank%22%3E%40Leigh_Barker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(A1%2CSheet2!A%3AB%2C2%2CFALSE)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20sheet2%2C%20cell%20A2%20the%20entry%20was%20%220001A%26nbsp%3B%20%26nbsp%3B%20%22%20with%204%20spaces%20after%20the%20value.%20As%20the%20formula%20looks%20for%20an%20exact%20match%2C%20%23NA%20was%20returned.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.

@Quadruple_Pawn 

 

Thank you. So simple..

 

LB