Pulling data from unusual table

[BT_9328149]

I'm looking for a way pull a specific value from a matrix by specifying the Y value through a drop down menu and the X value by interpolating the temperature. See figures.  I can't figure out a way for Mathcad to use a value in one matrix to determine a value in a different matrix. Hopefully one of you have an idea. See the figures for the tables and what I have pulled into Mathcad from Excel.

 

 

[terryhendicott]

Hi,

Can you include the worksheet so we don't have to do a lot of typing to reproduce the table.

Cheers

Terry

[BT_9328149]

Of course. I attached it here. Mathcad Prime 9.

[terryhendicott · Accepted solution]

Hi,

Like This:-

[terryhendicott]

Hi,

Prime is unit aware so it is not necessary to divide by the units.

Cheers

Terry

[BT_9328149]

Thank you for the clarification.