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

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Using lookup function with 2 inputs

CB_11858308
2-Guest

Using lookup function with 2 inputs

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

ACCEPTED SOLUTION

Accepted Solutions
Werner_E
25-Diamond I
(To:CB_11858308)

Maybe that way

Werner_E_0-1725618290624.png

 

Prime 9 sheet attached

 

View solution in original post

4 REPLIES 4

Hi Ciaran,

welcome to the community.

Here is one way to do it.

Capture.JPG

Cheers

Terry

Thanks very much, that was really helpful!

 

Ciaran

Werner_E
25-Diamond I
(To:CB_11858308)

Maybe that way

Werner_E_0-1725618290624.png

 

Prime 9 sheet attached

 

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

 

Ciaran

Announcements

Top Tags