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?
ACCEPTED SOLUTION
Accepted Solutions
@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.
You should attach the prime worksheet.
Try this on the placeholder for RFsplice[i,2:
Success!
Luc
@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.
