Vlookup error

%3CLINGO-SUB%20id%3D%22lingo-sub-1725880%22%20slang%3D%22en-US%22%3EVlookup%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725880%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%3C%2FP%3E%3CP%3EWhen%20I'm%20trying%20to%20use%20the%20V%20lookup%20I'm%20getting%20N%2FA%20for%20same%20value%20.e.g%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20used%20everything%20same%2C%20used%26nbsp%3B%20trim%20and%20Len%20formula.%20Any%20suggestion%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22vlook.PNG%22%20style%3D%22width%3A%20424px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222859i04968BAE87D94C5A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22vlook.PNG%22%20alt%3D%22vlook.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1725880%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-1726035%22%20slang%3D%22de-DE%22%3ESubject%3A%20Vlookup%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726035%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813758%22%20target%3D%22_blank%22%3E%40dipanjana812%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIt%20is%20said%20that%20a%20picture%20is%20worth%20a%20thousand%20words%2C%20but%20in%20the%20case%20of%20the%20Excel%20it%20is%20certainly%20not%20the%20most%20helpful.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20explain%20your%20plan%20by%20adding%20something%20to%20your%20question%20in%20the%20file.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EThis%20means%20that%20you%20can%20be%20helped%20faster%20and%20more%20accurately%20and%20it%20is%20made%20easier%20for%20the%20helpers%20to%20offer%20you%20a%20tailor-made%20solution.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22%22%3EIn%20theory%2C%20there%20can%20be%20many%20sources%20of%20error%2C%20but%20to%20be%20sure%20you%20need%20the%20file%2C%20otherwise%20you%20have%20to%20guess.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi ,

When I'm trying to use the V lookup I'm getting N/A for same value .e.g

 I have used everything same, used  trim and Len formula. Any suggestion?vlook.PNG

2 Replies

@dipanjana812 

It is said that a picture is worth a thousand words, but in the case of the Excel it is certainly not the most helpful.

If I can recommend you, add a file (without sensitive data) and explain your plan by adding something to your question in the file.

This means that you can be helped faster and more accurately and it is made easier for the helpers to offer you a tailor-made solution.

In theory, there can be many sources of error, but to be sure you need the file, otherwise you have to guess.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@dipanjana812 

First of all try simply compare the cells you lookup, like =cell1=cell2. If FALSE, something is wrong with your data. If TRUE, formula is incorrect.