Hi @Lauren Y

I would use the MATCH function to find the first "Red" for the RGY range.😁

Then, using the match position, use the INDEX function to look up the "Health Type" range.

I used the first row in my example, but if you want to use the column formula, you must prepare another sheet with a number column and a Health Type column.

If you want to find out all the "Red" as the Reason, first concatenate with the JOIN function and with the SUBSTITUTE function, convert "Red" to "R," "Green" to "G" and "Yellow" to "Y."

The conversion will give you something like "GGRYGRY."

Then, with the FIND function, find the second position of "R."  

(If you want the third position or Health Type, do the same.)