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

[dm-3]

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

[MikeArmstrong]

Is this what your after?

Mike

[dm-3]

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

[MikeArmstrong · Accepted solution]

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