Get figures from multiple data tables

Hi

I am trying to gather figures from a range of multiple data tables.

I have added an example which i hope is clear enough for you, I will try and explain using the actual cells in the attachment.

A4 to A9 reprsents the name of the table to use, marked in yellow
B4 to B9 represents the vertical orange cells in each table.
D2 represents the horizontal cells in each table which will be a validation list check box.

I need the associated figure in the data tables to appear between D4 to D9 which i have manually input as an example.

Thank you

Copy and paste this into D4; copy down.

Formula:

Please Login or Register  to view this content.

Hope it helps.

Also with the named lookup table ranges that Ford referred to paste this one in D4. It must be confirmed with Ctrl + Shift + Enter.

Formula:

Please Login or Register  to view this content.

Originally Posted by FDibbins

NIce 1, Flame, but wow, offset, indirect AND ARRAY...if that gets used in a lot of cells, it could really slow things down

hmm although, if the cell is recalc'ing anyway because of 1 volatile function, Im not really sure how 2 additional VF's will affect it

Good point. But golly it was fun to build....lol . Your idea of naming the tables/indirect kinda' inspired something.

I was also a little uneasy about my formula posted in #3.....what if the actual data isn't A,B,C....? Then relying on CODE function fails.

I want to thank you guys so much for your assistance, you really helped me more than you know

As for the ABC pointed out by FlameRetired, the actual format in the data axis will be 2/3 letters horizontal (red) and 3 letters vertical (orange) and the data figures in the tables is 00.00

Once again many thanks

An afterthought:

In Name Manager:

Formula:

Please Login or Register  to view this content.

In D4:

Formula:

Please Login or Register  to view this content.

and copy down. Does not have to be array entered.

Couldn't resist. Been looking for opportunity/excuse to use 4th argument (Areas) in the INDEX function. Couldn't wrap my mind around it. This just looked like the place to try it out.

Thanks for indulging me.