How to Correct

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.
VLOOKUP, Text Functions, and Paste Special are Essential Skills in Excel. I cover each of them in my 4 hour video training resource, "9 Essential Excel Skills." Visit my secure shopping site - shop.thecompany... - to learn more about my latest products.

[@DannyRocksExcels]

Thank you for your kind words!
I am pleased that I could help you with your VLOOKUP() issue.
Danny Rocks
The Company Rocks

[@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]

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]

My pleasure! Thank you for taking the time to add your feedback.
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

[@bijaymishra6774]

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

[@tauqeerrizvi]

This video is very helpful for me thanks Danny.

[@tamashii89]

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

[@shahramashrat]

u r genuise my friend. thanks for your time

[@romafrey2040]

I loved it. Thank you

[@jett6777]

THANK YOU SO MUCH

[@DannyRocksExcels]

Nate H - My pleasure.
I am happy that you enjoyed my Excel Tutorial on the VLOOKUP Function.
Sincerely,
Danny Rocks
The Company Rocks

[@lizbellinghoven1]

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