Community Tip - You can change your system assigned username to something more personal in your community settings. 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