Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns #n/a
I have two excel 2007 worksheets. Worksheet 1 is part numbers, worksheet 2 is
prices. The vlookup function is not returning the price against the respective part number. I have tried trim functions, clean functions, copying data to new worksheets, checked formats, saved worksheets in different formats and the error checking built into 2007 says there is an error but won't define the error. I have physically checked and the part number and prices are in sheet 2. Can anyone help ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns #n/a
Debra Dalgleish may be able to help:
http://contextures.com/xlFunctions02.html#Trouble Michael Dieckmann wrote: I have two excel 2007 worksheets. Worksheet 1 is part numbers, worksheet 2 is prices. The vlookup function is not returning the price against the respective part number. I have tried trim functions, clean functions, copying data to new worksheets, checked formats, saved worksheets in different formats and the error checking built into 2007 says there is an error but won't define the error. I have physically checked and the part number and prices are in sheet 2. Can anyone help ? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup returns #n/a
Thank you for the link. issue resolved.
"Dave Peterson" wrote: Debra Dalgleish may be able to help: http://contextures.com/xlFunctions02.html#Trouble Michael Dieckmann wrote: I have two excel 2007 worksheets. Worksheet 1 is part numbers, worksheet 2 is prices. The vlookup function is not returning the price against the respective part number. I have tried trim functions, clean functions, copying data to new worksheets, checked formats, saved worksheets in different formats and the error checking built into 2007 says there is an error but won't define the error. I have physically checked and the part number and prices are in sheet 2. Can anyone help ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Returns a zero value | Excel Discussion (Misc queries) | |||
VLOOKUP returns #REF! | Excel Worksheet Functions | |||
VLOOKUP returns #N/A | Excel Worksheet Functions | |||
VLOOKUP returns #N/A | New Users to Excel | |||
Vlookup returns a zero? | Excel Discussion (Misc queries) |