Returning Four Different Values For an IF Function

Good afternoon everyone. I am trying to determine membership status based on the number of volunteer events attended. For example, cell A1 would have the person's name, cell B1 would have a "1" if that person attended the first event, cell C1 would have a "1" if the person attended the second event, and so on. All the way in Column Z1, their membership status would be determined based off of the number of events they have attended (0 events attended would result in a "regular member", 1 event attended would be a "Bronze" member, 2 events a "Silver" member, and 3 or more events a "Bronze" member).

What is the formula I'd need in cell Z1 to make this all calculate the membership level automatically? Thanks so much for your help with this!

Try

=LOOKUP(SUM(A1:Z1),{0,1,2,3},{"Regular","Bronze","Silver","Bronze"})&" member"


Although, my guess would be you meant to say "Austin Powers" (Gold Member) for 3 or more events (you actually said Bronze for 3 or more)

Thank you! This worked like a charm. Allow myself to introduce myself.

You're welcome.