Match function to return variable name

[Casper123]

Hello, 

I'm not that experience with Mathcad, I do with excel, there the index match function is quite handy, something similar I would like to use in Math

I would like a lookup function in a matrix, to return as output from the matrix, not the value, but the name:

I'm not sure if it's even possible, have searched throughout the internet without results..

Thanks for helping!

[terryhendicott]

Hi,

Does this do:

[LucMeekes]

Like this... (in Mathcad 2001)

Unfortunately this functionality was lost in later versions of Mathcad, and Prime does not support it either,.

Success!
Luc

[Werner_E]

Your method works if we use an intermediate variable for the index which is inline evaluated numerically to stop the symbolics from trying to recalculate it.

[Werner_E · Accepted solution]

Simplification.

We can get rid of the Index variable, but inline evaluation still is necessary because "max" cannot be evaluated symbolically if units are used.

[Casper123]

Thanks @Werner_E much appreciated. 
Learned something new again 🙂

[Werner_E]

---

@Casper123 wrote:

Thanks @Werner_E much appreciated. 
Learned something new again 🙂

---

Me, too!
I wasn't aware that the symbolic evaluation of "max" would not work with units, even if we let Prime assume that all units are positive