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