Hello Community,
I'm pretty new to Mathcad, so I'm sure I'm just missing something quite basic and obvious.
What I'm trying to achieve is to use the results returned by the match function, to extract the equivalent rows from another variable.
Given variable A and var. B use the match function to find the row index for values greater or equal to 2.5 in B, and use those indexes to create a new var. containing the values in A for the indexes (or just print directly from A).
The result I was expecting was the new variable to return "Ac" and "Ad".
I originally thought it should be a fairly easy task, something like the shown in "Approach 03" of the screenshot.
However, I'm finding all sort of errors when trying different approaches. The more predominant error bein: "This value must be and integer"
Any help, please?
Thanks! 🙂
ACCEPTED SOLUTION
Accepted Solutions
Of course, as Stuart suggested, you should use “lookup” because this function does exactly what you want.
Just out of my own play instinct, two variants that still use “match” (not a recommendation!).
The first uses the already computed vector C with the index values to use and processes it in a loop.
The second variant uses “match” to find exactly the complementary indices and then uses them in the “trim” command to delete these lines.
As shown this also could be done in one go.
But as already mentioned, you sure should use “lookup” here and not fiddle around with "match".
