Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! 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