Why do I get #NA as my result when I write a vlookup formula?
 

When I write a vlookup formula, I receive an #NA error even though the values
to be looked up are found in the lookup table on Worksheet 2. Any ideas?

Why do I get #NA as my result when I write a vlookup formula?
 

First, post the formula you're using.

Second, explain the layout of your lookup table.

Third, check to see if the format of the cells being looked up differs from
the format of the lookup value (i.e., numbers formatted as text, etc.)

Any of those ideas could point to the issue.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"trainer07" wrote:

When I write a vlookup formula, I receive an #NA error even though the values
to be looked up are found in the lookup table on Worksheet 2. Any ideas?

Why do I get #NA as my result when I write a vlookup formula?
 

Most times what you think are the correct values have an extra space or two, so
they are not correct.

Try the TRIM function to get rid of any extra spaces.

If still needing help, post your formula and a small sample of data range from
worksheet2


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 15:38:00 -0800, trainer07
wrote:

When I write a vlookup formula, I receive an #NA error even though the values
to be looked up are found in the lookup table on Worksheet 2. Any ideas?