Is it possible to perform excel look-up in Mathcad?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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