VLOOKUP error

%3CLINGO-SUB%20id%3D%22lingo-sub-2860251%22%20slang%3D%22en-US%22%3EVLOOKUP%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860251%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20struggling%20to%20perform%20a%20VLOOKUP.%20The%20lookup%20value%20contains%20letters%20and%20numbers%2C%20is%20this%20why%20I'm%20getting%20the%20NA%20error%3F%3C%2FP%3E%3CTABLE%20width%3D%22139%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22139%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2860251%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2860306%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2860306%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189567%22%20target%3D%22_blank%22%3E%40Carys5%3C%2FA%3E%26nbsp%3BThe%20NA%20error%20means%20that%20VLOOKUP%20does%20not%20find%20an%20exact%20match.%20The%20lookup%20values%20may%20be%20texts%2C%20numbers%20or%20a%20mix%20of%20them%2C%20but%20a%20match%20will%20only%20be%20found%20if%20the%20other%20table%20also%20contains%20the%20exact%20same%20text%20or%20number.%20For%20example%3A%2010%20%3D%2010%20and%20%22name1%22%20%3D%20%22name1%22%20and%20will%20be%20found%20as%20matching%20values.%20However%2C%20the%20number%2010%20does%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20equal%20%22%2010%22%20(i.e.%20a%2010%20with%20a%20leading%20space).%20Likewise%2C%20%22name1%22%20does%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20equal%20%22name1%20%22%20(note%20the%20trailing%20space!)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm struggling to perform a VLOOKUP. The lookup value contains letters and numbers, is this why I'm getting the NA error?

 
3 Replies

@Carys5 The NA error means that VLOOKUP does not find an exact match. The lookup values may be texts, numbers or a mix of them, but a match will only be found if the other table also contains the exact same text or number. For example: 10 = 10 and "name1" = "name1" and will be found as matching values. However, the number 10 does not equal " 10" (i.e. a 10 with a leading space). Likewise, "name1" does not equal "name1 " (note the trailing space!)

Thanks, then I have no idea what I'm doing wrong. There is an exact value in the sheets I'm working on.

@Carys5 Can you share an example of your file. Just part of it, disclosing no confidential information.