Formula to reference named range

[Texastek76]

I have ~100 named ranges in a spreadsheet to reference daily production for oil wells. One data set is named AH717H for example. Typically I use a vlookup or Index Match like this: VLOOKUP(A2,AH717H,3,false) where A2 is a date. Pulling down this data for all ~100 wells which each have several hundred days of production makes the data set very large and the spreadsheet gets very big, very quick. Instead of using Vlookup for every well I'd like to be able to select a well from a list which could then cross-reference to the named range for that well.

For example - In cell A1 I'd pick the well Arroqhead 717H from a list. It would return a corresponding value in cell A2 of AH717H which is the correct named range. In another cell using Vlookup I would point to cell A2 to get the correct named range to refer to. Is that possible?

 

[Norie]

You could use INDIRECT.

=VLOOKUP(A2, INDIRECT(A2), 3, 0

 

[Fluff]

You could setup a table of Wells & their named ranges & use a Vlookup in A2 to return the named range & then use
=VLOOKUP(A3,INDIRECT(A2),3,FALSE)

 

[Texastek76]

That worked. Thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback