Skip to main content
A
amitshah1-Visitor
1-Visitor
May 10, 2012
Question

How to use Excel Vlookup features in Mathcad

  • May 10, 2012
  • 1 reply
  • 4043 views

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

    S
    StuartBruff23-Emerald V
    23-Emerald V
    May 10, 2012

    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

    Terms & ConditionsAccessibility statement