Vlookup Formula not working properly

[maverik]

I have applied Vlookup formula in my sheet but its not fetching the complete values as in some cells it shows N/A while if i check it manually the value dose exists in the other sheet. How to solve this issue.

 

[RichardMGreen]

What's your formula and what does your data look like?

 

[Spennny]

I have applied Vlookup formula in my sheet but its not fetching the complete values as in some cells it shows N/A while if i check it manually the value dose exists in the other sheet. How to solve this issue.

Are you sure there are no spaces before the letters in the sheet that your trying to pull the data from, are they the same spelling / format

Try going into one of the cells that your getting N/A from and retype the word

 

[c23lemon]

Please ensure that you you are comparing the same types of data. The problem you are encountering usually when you compare numbers and text.

 

[VBAdude]

Try using the Trim function on your data set before you use vLookup.

 

[maverik]

Yeh got it there was some format issue. I got it right and its perfect now. Thanks for all the suggestion.