cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

How to use Excel Vlookup features in Mathcad

amitshah
1-Visitor

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

1 REPLY 1
StuartBruff
23-Emerald III
(To:amitshah)

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

collab - lookup functions 01.jpg

Announcements

Top Tags