excel lookup ?

Matt Pinkston
Matt Pinkston used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi, pinkstonmp.

Please see attached.

Regards,
Brian.Check-Email.xls
Matt PinkstonEnterprise Architect

Author

Commented:
AWESOME!!!!!!
Thanks, pinkstonmp!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial