| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP with a Named Range argument
I am using a VLOOKUP to refer to a table that is a Defined Name/Named Range.
When I use the Defined Name directly in the function the Function works fine. Example: VLOOKUP(D8,NamedRange,2,False) However, if instead I reference the Named Range as it appears as a value in another cell, I get an #N/A error. Example: VLOOKUP(D8,C6,2,False) - where the value in C6 is NamedRange. It seems Excel is insisting on seeing the actual named range in the function and does not accept the named range value as it's returned from a single cell. Does anyone know of a workaround for this situation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a dynamic named range in a VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup in a named range | Excel Worksheet Functions | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| Vlookup in large named range | Excel Worksheet Functions | |||
| VLookup with concatinated named range | Excel Worksheet Functions | |||
Threaded Mode
