Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. 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