Home

VLOOKUP #N/A Error

%3CLINGO-SUB%20id%3D%22lingo-sub-756139%22%20slang%3D%22en-US%22%3EVLOOKUP%20%23N%2FA%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756139%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20facing%20the%20issue%20in%20vlookup%20formula%20once%20I%20put%20the%20formula%20in%20cell%20some%20cell%20pick%20the%20values%20and%20some%20cells%20are%20not%20picking%20the%20value%20even%20the%20find%20the%20name%20is%20same...%3C%2FP%3E%3CP%3E%26nbsp%3Bkindly%20help%20me%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EYasir%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-756139%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-756152%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20%23N%2FA%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F120453%22%20target%3D%22_blank%22%3E%40M.Yasir%20Fakhr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20may%20be%20space%20characters%20in%20the%20column%20you%20are%20trying%20to%20match.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%2C%20you%20might%20want%20to%20check%20the%20Range%20as%20well%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756508%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20%23N%2FA%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F120453%22%20target%3D%22_blank%22%3E%40M.Yasir%20Fakhr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20the%20first%20column%20of%20the%20table_array%20argument%20of%20your%20VLOOKUP%20has%20leading%2C%20trailing%2C%20or%20extra%20spaces.%20In%20such%20a%20case%2C%20you%20may%20use%20TRIM%20in%20LOOKUP%2C%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DLOOKUP(PI()%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E1%2F(TRIM(A%3AA)%3DD2)%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EB%3AB)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
M.Yasir Fakhr
Occasional Contributor

Dear all,

 

I am facing the issue in vlookup formula once I put the formula in cell some cell pick the values and some cells are not picking the value even the find the name is same...

 kindly help me

 

Thanks

Yasir 

2 Replies

@M.Yasir Fakhr 

There may be space characters in the column you are trying to match.   

If not, you might want to check the Range as well 

@M.Yasir Fakhr 

I guess the first column of the table_array argument of your VLOOKUP has leading, trailing, or extra spaces. In such a case, you may use TRIM in LOOKUP, like this: 

=LOOKUP(PI(),
1/(TRIM(A:A)=D2),
B:B)