I have a request from some employees that want an informational email to go out to specific employees depending on which team they're on. I currently have a field in my database set up that sets the "Team 1 member" flag to either true or false depending on certain criteria.

My problem is team 1 only has 1 member, so I can get the email to go to this person just find. My problem is with team 2 that has multiple members. I need to be able to send an email to all members of this team. How can I set K2 up to send emails to multiple employees based off of information in the table?