Using Multiple Tables to drive results

DavidWT87

New Member
Joined
May 10, 2023
Messages
25
Office Version
  1. 2016
Platform
  1. Windows
Hello.

I have a table of data in an excel sheet, and have created formulas to do some linear and bi-interpolation on the data which then gives me the values I need down the line for some testing.

This works fine as a stand alone solution, but I am hoping to create a standardised sheet that can be used in multiple situations. This demands consulting multiple tables, with certain input criteria determining which table is used to interpolate from.

Below is an example table, of which there are many. Let's say I have 5 tables - named Table D25 through Table D29, and those tables each have 3 different versions based on the year chosen (2010,2016 & 2020).

IE: 2010 Table D25, 2010 Table D26 etc etc
2016 Table D25, 2016 Table D26 etc etc
2020 Table D25, 2020 Table D26 etc etc.

What I would like to do is either have a couple of drop down boxes, from which I can choose the year, and table number, and have my interpolation formulas then look at the corresponding table, or have 1 table that my interpolation formulas work from but have that table get filled out with the corresponding values based on the drop down choices.

I figure I'm in the realms of LOOKUP tables to some degree, but not sure where to go from there.

Thanks

Auotmated Testing Analysis.xlsm
BCDEFGHIJKLMNOP
22010TABLE D25
3H70-T40 4-7kg Non-commsAPRR (Mpa/min)Target Pressure, Ptarget (Mpa)
4
5Initial Tank Pressure, P0 (Mpa)
60.5251015203040506070>70
7Ambient Temperature, Tamb (oC)<-40No FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo Fueling
8-4028.571.671.170.270.068.566.964.861.558.5No FuelingNo FuelingNo Fueling
9-3028.572.171.670.670.469.067.465.261.858.7No FuelingNo FuelingNo Fueling
10-2028.572.972.371.371.069.568.065.762.460.0No FuelingNo FuelingNo Fueling
11-1028.573.472.971.970.070.068.466.564.462.961.2No FuelingNo Fueling
12028.574.073.472.470.670.769.668.667.165.764.0No FuelingNo Fueling
131028.066.371.174.173.272.471.670.969.668.466.9No FuelingNo Fueling
142021.867.972.174.573.774.073.472.271.970.769.7No FuelingNo Fueling
152518.569.072.875.174.574.774.373.373.072.071.1No FuelingNo Fueling
163015.370.673.975.875.275.475.174.374.173.372.471.3No Fueling
173512.472.975.376.476.076.175.975.375.174.573.872.7No Fueling
184011.573.275.676.876.376.476.275.675.374.673.972.7No Fueling
19458.176.377.276.976.576.476.275.675.374.773.972.7No Fueling
20505.177.877.677.376.976.676.275.775.374.773.972.8No Fueling
21>50No FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo FuelingNo Fueling
J2601 TABLES
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,223,246
Messages
6,170,988
Members
452,373
Latest member
TimReeks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top