Skip to main content
1-Visitor
September 6, 2024
Solved

Using lookup function with 2 inputs

  • September 6, 2024
  • 2 replies
  • 1284 views

Hi, 

I'm brand new to Mathcad so apologies if this is a silly question. I'm trying to figure out how to check inputs for columns 0 and 1 to provide an output in column 3. In this case colum 0 input is 100, column 1 input is 3, and therefore column 3 output should be 1/2500.

 

With Excel i would use XLOOKUP and use '&' operator to combine 2 inputs. However, I can't figure out a way of doing this (yet) with Mathcad. Any advice?

 

CB_11858308_0-1725606380295.png

Thanks,

Ciaran

Best answer by Werner_E

Maybe that way

Werner_E_0-1725618290624.png

 

Prime 9 sheet attached

 

2 replies

21-Topaz II
September 6, 2024

Hi Ciaran,

welcome to the community.

Here is one way to do it.

Capture.JPG

Cheers

Terry

1-Visitor
September 6, 2024

Thanks very much, that was really helpful!

 

Ciaran

Werner_E25-Diamond IAnswer
25-Diamond I
September 6, 2024

Maybe that way

Werner_E_0-1725618290624.png

 

Prime 9 sheet attached

 

1-Visitor
September 6, 2024

Thank you very much, that was really helpful! That solution worked perfectly.

 

Ciaran