Skip to main content
D
dm-31-Visitor
1-Visitor
July 5, 2011
Solved

Is it possible to perform excel look-up in Mathcad?

  • July 5, 2011
  • 1 reply
  • 2847 views

Hi,


I would like to know if it is possible to evaluate the equation by substituting the value of corresponding variable in second column of table by giving the input from variable in first column of same table in Mathcad.

--

Dhinesh

Best answer by MikeArmstrong

How you did that?

I have included a brief description in the attached worksheet.

Is it possible to add that Mathcad have to throw a message if the value is not in the table?

Yes, by using the 'on error' function, see attached also.

Mike

1 reply

M
MikeArmstrong1-Visitor
1-Visitor
July 5, 2011

Is this what your after?

Mike

D
dm-31-VisitorAuthor
1-Visitor
July 5, 2011

Mike,

This is the one.

How you did that?

Is it possible to add that Mathcad have to throw a message if the value is not in the table?

--

Dhinesh

M
MikeArmstrong1-VisitorAnswer
1-Visitor
July 5, 2011

How you did that?

I have included a brief description in the attached worksheet.

Is it possible to add that Mathcad have to throw a message if the value is not in the table?

Yes, by using the 'on error' function, see attached also.

Mike

Terms & ConditionsAccessibility statement