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?