Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |