Forum Discussion
Cameron Greenfield
Sep 02, 2018Copper Contributor
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...
Philip West
Sep 03, 2018Steel Contributor
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.
Cameron Greenfield
Sep 03, 2018Copper Contributor
Thank you, works great :)