VLOOKUP with a Named Range argument

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?
 
J

John C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Ranges and Dynamic Formulas 3
Refer to a named range indirectly 2
vlookup, concatenated named range 4
Using Value of a Cell in the Range Reference in VLOOKUP 1
Linked Named Ranges 2
a data validation list that contains a list of named ranges - not alist from a named range 1
Use Text and Cell vale to reference a named range inside a formula 1
Hyperlink to named range in workbook 1

Top