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

How do I have a cell value define a dynamic named range? 15
Use Text and Cell vale to reference a named range inside a formula 4
a data validation list that contains a list of named ranges - not alist from a named range 1
Go To a Named Range (2nd posting) 5
A find formul looking at two named ranges for two strings 8
Formula Based on Values in Named Range Q 5
Range headings 0
trouble with (complicated) vlookup searching another workbook 2

Top