topic Re: Specify name to a row in a matrix in Mathcad

Specify name to a row in a matrix

WS_11796812 — Thu, 29 Aug 2024 15:26:19 GMT

Trying to display the corresponding controlling condition associated with Column 1 to be displayed to the right. Is there a way this can de done simply?

Re: Specify name to a row in a matrix

LucMeekes — Thu, 29 Aug 2024 21:18:51 GMT

You should attach the prime worksheet.

Try this on the placeholder for RFsplice[i,2:

Success!
Luc

Re: Specify name to a row in a matrix

Werner_E — Thu, 29 Aug 2024 23:42:03 GMT

@LucMeekes wrote:

You should attach the prime worksheet.

Try this on the placeholder for RFsplice[i,2:

Success!
Luc

Haven't you forgotten the third function argument (1) of "vlookup"?

Maybe also a vector index 0 at the end, so the result is just the string and not a vector containing the string.

Even though I guess thats it not necessary here, a sophisticated approach would be

as it returns a single string in the normal case (?) that the minimum is present in just one of the three matrices, but also covers the case that it may be present in two or all three matrices.

Re: Specify name to a row in a matrix

LucMeekes — Fri, 30 Aug 2024 06:40:28 GMT

Yes, I did forget about that. 😔

Fortunately there's you, to correct my silly mistake. 🙂

Luc

Re: Specify name to a row in a matrix

WS_11796812 — Fri, 30 Aug 2024 14:13:52 GMT

Thanks that works

Re: Specify name to a row in a matrix

Werner_E — Mon, 02 Sep 2024 11:45:58 GMT

@WS_11796812 wrote:

Thanks that works

Actually it was Luc providing the initial solution. I just jumped in to point out that he accidentally forgot about the third function argument.

With my elaborate version you will see a vector with two or maybe even three entries if by chance the two or all three values in your three vectors have the same (min) value. Not sure if this could happen with your data and if you really need that option.