Home

Vlookup returning N/A except for three cells

%3CLINGO-SUB%20id%3D%22lingo-sub-386342%22%20slang%3D%22en-US%22%3EVlookup%20returning%20N%2FA%20except%20for%20three%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386342%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20first%20two%20columns%20setup%20as%20table%203%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20doing%20a%20simple%20vlookup%20and%20the%20formula%20is%20only%20returning%20three%20cells%20with%20details%2C%20doesn't%20make%20sense%20the%20formatting%20is%20all%20the%20same.%20What%20is%20going%20wrong%3F%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-386342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Evlookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386417%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20returning%20N%2FA%20except%20for%20three%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306919%22%20target%3D%22_blank%22%3E%40TMAZZ%3C%2FA%3E%20%2C%20most%20probably%20that%20means%20you%20have%20no%20exact%20match%20of%20your%20values.%20Try%20to%20compare%20the%20manually%20if%20text%20is%20identical%2C%20e.g.%20test%20%3DH14%3DB37%3C%2FP%3E%3C%2FLINGO-BODY%3E
TMAZZ
New Contributor

I have the first two columns setup as table 3, 

 

I'm doing a simple vlookup and the formula is only returning three cells with details, doesn't make sense the formatting is all the same. What is going wrong?

 

 

1 Reply
Highlighted

@TMAZZ , most probably that means you have no exact match of your values. Try to compare the manually if text is identical, e.g. test =H14=B37

Related Conversations