How can I tell which column a value occurs in?

[Berrett]

I have columns for Ethnicity in this student data but the values are split across five columns (see attached). I need to fill in the Purple column (Column N) with a single Ethnicity value. So Row 2 would be "White", Row 12 would be "Black". I have been trying for 30 minutes and I just can't find a way to make this work.

Any thoughts?

 

[Fluff]

How about

=INDEX($I$1:$M$1,MATCH("Yes",I2:M2,0))

 

[Berrett]

How about

=INDEX($I$1:$M$1,MATCH("Yes",I2:M2,0))

That totally worked! Wow - thanks so much. I'm so glad this site still exists. It's amazing

 

[Fluff]

You're welcome & thanks for the feedback.