Hello
I am hoping to have a table of data that changes based on the inputs chosen.
i.e - I have a blank table I want to use in combination with some formulas, and want a user to be able to choose a Year and Table No. from drop down boxes, and then have that corresponding reference table copy itself into my blank table - which my other formulas will then look at to pull out the data I need.
I could probably figure out how to do it with a lot of if statements, (but it would get horrendously complex- this is just a snapshot example and in reality there are going to be 30-40 reference tables so am wondering if there is something more elegant I can do to deal with that amount of data.
Thanks in advance
I am hoping to have a table of data that changes based on the inputs chosen.
i.e - I have a blank table I want to use in combination with some formulas, and want a user to be able to choose a Year and Table No. from drop down boxes, and then have that corresponding reference table copy itself into my blank table - which my other formulas will then look at to pull out the data I need.
I could probably figure out how to do it with a lot of if statements, (but it would get horrendously complex- this is just a snapshot example and in reality there are going to be 30-40 reference tables so am wondering if there is something more elegant I can do to deal with that amount of data.
Thanks in advance
Cell Formulas | ||
---|---|---|
Range | Formula | |
X26:AF38 | X26 | =L26+1 |
L45:T57 | L45 | =L26+2 |
X45:AF57 | X45 | =L26+4.5 |
L64:T76 | L64 | =L26+1.2 |
X64:AF76 | X64 | =L26+1.9 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
F7:G7 | List | D25,D26 |
F5:G5 | List | 2010,2016,2020 |