dynamic list using offset and indirect

[ncarrocino]

I created a dynamic drop down list that has the five items to select from. when i select a category i want it to show the three corresponding data sets that go with only that item. I tried an offset with indirect function ( =offset(indirect("$S$4),0,0 ) but i can not get it to work. Ive attached my file with only two rows but they will always be expanding.

when you select "n-feed" from the drop down the numbers 14.3 2.0 2.0 should appear to the right, and under it 12.9 3.6 3.6. and also the date! thanks

Nano Filtration for liz.xls

[Pepe Le Mokko]

I suggest you first get rid of the merged cells ,which are nothing but trouble, first.

[ncarrocino]

consider them gone! I just can not get the indirect function to refer to the dynamic list. It instead is referencing "S4" where the drop down list is

[ncarrocino]

any other ways to do it are also welcome!

[protonLeah]

Create three dynamic names:
1. AshTable:

Please Login or Register  to view this content.

2. GATable:

Please Login or Register  to view this content.

3. SolidsTable

Please Login or Register  to view this content.

In your summary/report table use:

Please Login or Register  to view this content.

I deleted your named range "test"
I deleted row one
I unmerged cells