How to Correct

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

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

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

[@bijaymishra6774]

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

[@DannyRocksExcels]

My pleasure! Thank you for taking the time to add your feedback.
Danny Rocks
The Company Rocks

[@tauqeerrizvi]

This video is very helpful for me thanks Danny.

[@DannyRocksExcels]

Thank you for adding your comment. I am pleased that you enjoyed my tutorial.
Danny Rocks
The Company Rocks

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

[@lizbellinghoven1]

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

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