Specify name to a row in a matrix

[WS_11796812]

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?

[LucMeekes]

You should attach the prime worksheet.

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

Success!
Luc

[Werner_E · Accepted solution]

---

@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.

[LucMeekes]

Yes, I did forget about that. 😔 

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

Luc

[WS_11796812]

Thanks that works

[Werner_E]

---

@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.