| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Returns #NA For text/numbers with a dash -
Working with 2 spreadsheets - trying to look up by value A1 (Item number).
Many of the rows work correctly...however for item numbers that contain a dash (-) (Example: 10050-4) the result is #NA. I have verified that the item number is on both worksheets. I have tried converting the item to text and numeric, but all entries that include a dash - return #NA. Please help. -- Tickfarmer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP JUST RETURNS THE TEXT OF THE COMMAND | Excel Worksheet Functions | |||
| inserting a dash into a column of numbers | Excel Worksheet Functions | |||
| vlookup returns #N/A if value contains letters and range numbers | Excel Discussion (Misc queries) | |||
| remove a dash from part numbers | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Threaded Mode
