I am trying to set up a spreadsheet based off of several different tables of information. I have cells with pulldown lists in them. These lists form the column and row titles of these tables... I want to be able to select these pulldowns and in a third cell have the results of those pulldowns produce the corresponding cell in the table they apply to.
I have tried VLOOKUP, HLOOKUP and others but these formulas require that I enter the column or row number, but doesn't let me compare the names in the rows and columns with those I selected from the pulldown lists. The formulas get too long if I am to assign each row/column header with a number.
For example, I have two pulldown cells: one pulldown choice is "Group Type" and I choose "Group B". Another is "Construction Type" and I select "Type I-A"... The table looks like this:
A B C D
1 Type I-A Type I-B Type II-A
2 Group A 10,000 20,000 30,000
3 Group B 15,000 25,000 35,000
4 Group C 20,000 25,000 30,000
I want a stand-alone third cell to automatically produce "15,000". If I then go back and change my pull-down selections, this result changes accordingly.
If this makes sense, can anyone be of assistance? Thanks.
List One: Group A-1, Group A-2, Group B, Group E, Group M, etc...
List Two: Type I-A, Type I-B, Type II-A, Type II-B, etc..
My Table consists of columns with the Groups in them, rows with the Types in them. Here is the table:
TYPE I-A TYPE I-B TYPE II-A TYPE II-B
A-1 UL UL 15,500 sf 8,500 sf
A-2 UL UL 15,500 sf 9,500 sf
A-3 UL UL 15,500 sf 9,500 sf
A-4 UL UL 15,500 sf 9,500 sf
A-5 UL UL UL UL
B UL UL 37,500 sf 23,000 sf
E UL UL 26,500 sf 14,500 sf
So, if in one pulldown list I select "A-2", and in the other pulldown list I select "Type II-A", in a 3rd cell, I want "15,500 sf" to appear. If I change the pulldown to "B", I want the 3rd cell to change to "37,500 sf".