How to use Excel Vlookup features in Mathcad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to use Excel Vlookup features in Mathcad
Hi,
There are couple of sheets in Excel drawn with tables. With the Vlookup functionality I can pull any cell of any sheet in to my calculation part.
Is there any feature available in Mathcad which can perform the same action.
I have attached a ref sheet, which exactly explains the requirement.
Thanks
Amit
- Labels:
-
Other
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
amit shah wrote:
There are couple of sheets in Excel drawn with tables. With the Vlookup functionality I can pull any cell of any sheet in to my calculation part.
Is there any feature available in Mathcad which can perform the same action.
I have attached a ref sheet, which exactly explains the requirement.
You can use the lookup functions in Mathcad: lookup, vlookup, hlookup and match. The attached worksheet gives an example of how you could use them.
Stuart
