IFS? INDEX? MATCH? Help

[jdlueken]

I'm trying to figure out a formula to return whether or not a ClassID is eligible for a program or not.

Matching the ClassID on sheet 2 with sheet 1, and returning a Yes if there is a yes anywhere in the row of that ClassID. Or a No if there is not.

The caveat is there are multiple instances of the ClassID in sequential rows on sheet 2.

 

[jdlueken]

Or even return the header of the column if there is a Yes might actually be better. Unsure how to edit my previous post.