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 - http://shop.thecompanyrocks.com - to learn more about my latest products.
Watch video How to Correct online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 04 October 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 471,081 once and liked it 2 thousand people.