Use Vlookup to insert a named range for the vlookup Table

I've a series of 370 tables each with their own named range. I am want to have a nested vlookup, whereby the Table Array for the first Vlookup is determined by another lookup function.

The data for the primary vlookup is set out as follows:

Column A = Lookup Value
Column B (not relevant)
Column C = NamedRange Name of the Table array

A Data Validation List box selects the "Lookup Value", from Column A, the Data Validation List box is located in a cell that I have renamed as a named range "LGA"

Each of the named ranges for the 370 tables of data corresponds to the name included in Column C.

The Vlookup I had envisaged when something like this:

=Vlookup(LGA,Vlookup(LGA,A2:C372,3,False),2,False)


If I take the second VLookup by itself, that is, Vlookup(LGA,AS:C372,3,False) the formula will work properly and return a value such as "Abcdefg".

When I type the primary Vlookup as Vlookup(LGA,Abcdefg,2,False) it returns the result I expect it to (based upon the content of Named Range "Abcdefg").

The objective is to make Vlookup dynamic, so that by simply changing the valued selected in the Data Validation List box (LGA), I can change the Table Array the Vlookup command inspects.

Any thoughts?

Michael

Hello and welcome to the forum.

If I am understanding you correctly, try this:

=VLOOKUP(LGA,INDIRECT(VLOOKUP(LGA,A2:C372,3,FALSE)),2,FALSE)