If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
VLOOKUP with a Named Range argument
Your formula of VLOOKUP(D8,C6,2,False) is looking at C6 as the named range,
not containing the named range. Basically, it is trying to match D8 to the table of C6. You should try: =VLOOKUP(D8,INDIRECT(C6),2,FALSE) Hope this helps. -- John C "modernminstrel" wrote: 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 | |
Display Modes | |
|
|