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

Defining a dynamic table_array for vlookup 9
VLookup formula transposing table_array when copied to another cel 1
Vlookup to reference offset 1
vlookup with dynamic table_array 3
choose table_array in VLOOKUP from list of multiple worksheets? 5
AppleScript - How do I select a text ? 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Help creating a search form in Access XP 0

Top