Narrow a search field to 6 or 7 entries, use another input, then choose 1 entry

[tfiedler]

Good Morning!

On the attached spreadsheet, I am attempting to find the exact "Tube Factor" based on a number of inputs.

On the Radiator Capacity Tab, G20 has a look up based on the inputs in K27 and K28. These two inputs narrow down what type of tube is required from the ES Tab, then search the Tube Area (ES-19, ES16) and Tube Area (ES-25,ES16) tabs for the corresponding tube factor, or tube cross sectional area.

Currently this only pulls the first entry in the Tube Nubmer section.

What I would like, is, with the addition of one more input, K29 (Wall Thickness) on the Radiator Capacity Tab to find the correct area based on the wall thickness.

So in the end, I use the drop down menu to select the Core Design Construction and Core Code, which narrows down what tube number I have to use. I then enter the Wall Thickness (Probably another drop down menu, just haven't gotten that far) Then it looks up the areas of that number of tube based on wall thickness.

I hope that has come across clear enough.

Thanks for your help.