Select Range Relative to SINGLE Cell Reference

[colpaz]

Hello there!
I've been scratching my head over this one for a while, and countless searches have left me more confused than when I started - so I'm hoping someone on here can lend a hand!

I have a spreadsheet that has two graphs in one tab that look to another tab for their data. The data displayed on the graphs differs based on a pulldown selection.

The pulldown selection corresponds to the title of each of a number of different sets of data on the tab the graphs look to for their data.

What I'd like to do is this:
-when a pulldown selection is selected, the graphs should then look (probably via formulas in a named range) to the data set that matches that pulldown....
-this means that any reference to the range that the data is in will have to be relative to the title of that range of data - this is important so that more data sets can be added in the future without adding more named ranges

Any ideas?

Attached is a pic of the data sets - how do I reference relative to the title cell??

[DonkeyOte]

Post a sample of the file rather than a screenshot ... it's impossible to know from the screenshot how your named ranges are defined etc or even the ranges in play ...

However, I would point out you could create a range based on a value in A ... let's assume the criteria values (eg C172N) is in cell A1:

Please Login or Register  to view this content.

Or if you have named the range B11:H16 as say _C172N you could just INDIRECT...

Please Login or Register  to view this content.

(note the use of underscore in the named range... given the nature of your references this is not a bad approach to naming your ranges)