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...
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 :)
