Skip to main content
1-Visitor
February 28, 2019
Solved

return value from the intersection of a particular row and column in a table

  • February 28, 2019
  • 1 reply
  • 1619 views

Hello,

 

I have the attached mathcad with the inputs: "a", "b" and "Table". "a" should be looking in the first row of "Table" to find a match, vector "b" should be looking in the first column of "Table" to find a match for each value of the vector. The final result should return the result from the intersection of the column and line previously identified to get the result from "Table". 

 

Thank you,

Otilia

Best answer by Werner_E

Here's one way to do it. Another way might be using 2-dimensional interpolation

B.png

1 reply

Werner_E25-Diamond IAnswer
25-Diamond I
February 28, 2019

Here's one way to do it. Another way might be using 2-dimensional interpolation

B.png

Otilia1-VisitorAuthor
1-Visitor
February 28, 2019

Thank you Werner_E. Problem solved with your help.