Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
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
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

