Using lookup function with 2 inputs
‎Sep 06, 2024
03:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Sep 06, 2024
03:10 AM
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?
Thanks,
Ciaran
Solved! Go to Solution.
Labels:
- Labels:
-
Mathcad Usage
-
Programming
ACCEPTED SOLUTION
Accepted Solutions
‎Sep 06, 2024
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
4 REPLIES 4
‎Sep 06, 2024
03:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Sep 06, 2024
03:28 AM
Hi Ciaran,
welcome to the community.
Here is one way to do it.
Cheers
Terry
‎Sep 06, 2024
06:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Sep 06, 2024
06:21 PM
Thanks very much, that was really helpful!
Ciaran
‎Sep 06, 2024
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Sep 06, 2024
06:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Sep 06, 2024
06:21 PM
Thank you very much, that was really helpful! That solution worked perfectly.
Ciaran