Avatar of Matt Pinkston
Matt Pinkston
 asked on

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

Avatar of undefined
Last Comment
redmondb

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
redmondb

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Matt Pinkston

ASKER
AWESOME!!!!!!
redmondb

Thanks, pinkstonmp!
Your help has saved me hundreds of hours of internet surfing.
fblack61