Refer to a named range indirectly

T

tberkom

I'm looking to refer to a named range in a VLOOKUP formula that gets its
value from another cell. In other words, the cell contains a text value that
matches a named range in the workbook and I would like to capture that named
range in a VLOOKUP formula by reference to the cell that contains the named
range value. Hope that is clear enough...
 

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

Use Text and Cell vale to reference a named range inside a formula 1
How do I have a cell value define a dynamic named range? 15
a data validation list that contains a list of named ranges - not alist from a named range 1
VLOOKUP with a Named Range argument 1
Linked Named Ranges 2
Referring to specific cell in named range in Excel formula 3
Formula Based on Values in Named Range Q 3
Dynamic Named Ranges 3

Top