excel lookup ?

I have a spreadsheet with two tabs:

Report
Roster

On the tab report I have a bunch of columns on is column J (PSM) which is a email address, I need to compare this to tab roster column F (email) and in the report tab indicate when the PSM column does not have a match in the roster tab email column.
Matt PinkstonAsked:
Who is Participating?
 
redmondbConnect With a Mentor Commented:
Hi, pinkstonmp.

Please see attached.

Regards,
Brian.Check-Email.xls
0
 
Matt PinkstonAuthor Commented:
AWESOME!!!!!!
0
 
redmondbCommented:
Thanks, pinkstonmp!
0
All Courses

From novice to tech pro — start learning today.