Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Matt Pinkston
Matt Pinkston

ASKER

AWESOME!!!!!!
Thanks, pinkstonmp!