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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

474,807 views November 9, 2012 6:03

Watch on YouTube
ChannelDanny Rocks

Description from the creator

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.

About this tutorial

Danny Rocks published this 6:03 video tutorial on November 9, 2012. It has been watched 474,807 times on YouTube.

Category
Education
Duration
6:03
Published
November 9, 2012
Views
474,807
Likes
2,061

Tags

Share

This tutorial in other languages