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

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?

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

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.

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

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

Thanks, I was playing around with that... I really appreciate your help.

"Max" wrote:

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.

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

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

Welcome, thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Sean R" wrote in message
...
Thanks, I was playing around with that... I really appreciate your help.