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.thecompanyrocks.com - to learn more about my latest products.
3 окт 2012
