cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

dm-3
1-Newbie

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
MikeArmstrong
4-Participant
(To:dm-3)

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

View solution in original post

3 REPLIES 3
MikeArmstrong
4-Participant
(To:dm-3)

Is this what your after?

Mike

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
4-Participant
(To:dm-3)

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

View solution in original post

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."