Forum Discussion
Pulling a single value from a set of multiple tables based on 3 selections
Hi there,
I am trying to have a single value generate in a cell based on 3 drop down selections. I have attached screen shots to help explain what I am trying to do.
I have 6 tables of values depending on the height of a wall. The wall height drop down selection in position C10 needs to dictate what table is referred to based on this height.
I then want the next 2 selections of steel thickness (0.55-1.20) and stud centers (450, 600) to have excel pull the value from the table (table based on wall height) and generate it in the cell which I am typing the formula into (G10).
Any help would be greatly appreciated :)
Hi Cameron,
I think if you rearrange your data table then it should be quite easy to do. Rather than have 6 tables of data that you then try to select from, have 1 data of table with a column for the height of the wall, the thickness of the steel and the two stud centers
Something like this:
height thinkness 450 600 2100 0.55 0.66 0.9 2100 0.75 1.44 1.96 2400 0.55 0.58 0.79 2400 0.75 1.26 1.72 From this table you can use an index(match,match) to look up the result.
I've attached an example of the above for you.
Thank you, works great :)
