Search for multiple email address at once

I have a master list of college football coaches that I have sent emails to. Using Gmass, I'm able to download a spreadsheet of all the coaches who have/haven't opened the email, or if the email address bounces. On sheet #2 (Did-not-open) is the list of coaches that haven't opened their email. Is there a way I can use that list to search the same address in sheet#1 (schools) at the same time so I can mark them accordingly. I know I can use the filter and type in the search one address at a time, but I'm trying to same time. Thanks

Originally Posted by AliGW

You've posted in the other platforms section, so which platform are you using? This will determine any solutions offered.

I’m using excel 2016 on an IMac.