How to Correct #N/A Error Messages for VLOOKUP Function in Excel

One of my viewers cannot figure out why he is receiving the #N/A Error Message for his VLOOKUP() Function results. He is an experienced Excel user and has set up the VLOOKUP Function correctly.

Why the #N/A error messages?

As I suspected, the "table Array" - which is the information that was downloaded from his company's Main Frame Computer has set each Data Field as Fixed Width.

During this tutorial, I use the LEN() and the TRIM() Functions to diagnose and then correct the problem.

[ravitejamom]

Tried the same. But still no use from i am not able to solve the issue.
When i used =LEN() both the columns is showing same same digits as 10 .
Even though it is showing 10 i have done the TRIM for both columns but no use.
please try to solve my issue.
i am using MS Excel 2007

[DannyRocksExcels]

Thank you for your kind words!

I am pleased that I could help you with your VLOOKUP() issue.

Danny Rocks
The Company Rocks

[DannyRocksExcels]

My pleasure! Thank you for taking the time to add your feedback.

Danny Rocks
The Company Rocks

[bijaymishra]

Thank you Danny, you trick helped me to nail down the issue I had in Vlookup.
Liked the simple teaching method!!!

[DannyRocksExcels]

Hi Richard -
Thanks for adding your comment. I am really pleased that I could help you to solve your specific work-related problem.

This makes my day!

Danny Rocks
The Company Rocks

[DannyRocksExcels]

Thank you for adding your comment. I am pleased that you enjoyed my tutorial.

Danny Rocks
The Company Rocks

[DannyRocksExcels]

Re: TRIM() Function combined with VLOOKUP(). -

Personally, I would perform trim as a separate operation. Do this prior to using VLOOKUP().

Danny Rocks
The COmpany Rocks

[shahramashrat]

u r genuise my friend. thanks for your time

[lizbellinghoven]

just wondering if you could include the trim() function as a parameter in the vlookup() function...

[tauqeerrizvi]

This video is very helpful for me thanks Danny.

[tamashii]

Great video, Danny, it just helped me out to solve a specific problem at work.

Regards,

Richard