M
modernminstrel
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?
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?