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

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

  • July 5, 2011
  • 3 replies
  • 2863 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

3 replies

MikeArmstrong1-Visitor
1-Visitor
July 5, 2011

Is this what your after?

Mike

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

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