How do I reference a "range" for a specific table_array in VLOOKUP

S

Sean R

I am using a drop down menu in A1 to reference 28 different table "ranges"
that I've named (end entered data into) on another sheet.

In A2, I use a dropdown menu to select the Row I will be VLOOKUP(ing) from
the table range I selected in A1.

In A3, I would like to the use VLOOKUP and have it read the Text for the
range name I've selected in A1, and enter that into the table_array position.

How do I have it "read" text and insert that variable text into the
table_array position?

Does my question even make sense?
 
M

Max

In A3, I would like to use VLOOKUP and have it read the Text for the
range name I've selected in A1, and enter that into the table_array position.
Click to expand...

INDIRECT holds the key

If A1 houses the DV for the named ranges
then something like this will work:
=VLOOKUP(B2,INDIRECT(A1),2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
 

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

Cell Reference for table_array in Vlookup 1
Defining a dynamic table_array for vlookup 9
VLookup formula transposing table_array when copied to another cel 1
choose table_array in VLOOKUP from list of multiple worksheets? 5
vlookup template -> table_array 1
In VLOOKUP how to pick Table_array value from a cell 1
vlookup table_array reference listed in another cell 2
Insert Vlookup into table_array of Vlookup with named range 1

Top