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

  • Thread starter Thread starter Sean R
  • Start date Start date
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?
 
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
---
 
Back
Top