| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP error
I am trying to use a VLOOKUP from a large set of data to a smaller set of
data (the array does not contain all of the values being looked up), and thus returns #N/A. It works for the first value which is in the table, but as soon as there is a value missing, all other returns are #N/A as well. Is there any way to get around these absent values? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REF# error using VLOOKUP | Excel Worksheet Functions | |||
| vlookup error - recognition of value | Excel Worksheet Functions | |||
| Fill down error for Vlookup | Excel Worksheet Functions | |||
| vlookup weird error | Excel Worksheet Functions | |||
| vlookup error | Excel Discussion (Misc queries) | |||
Threaded Mode
