• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

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.
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
1 Solution
 
redmondbCommented:
Hi, pinkstonmp.

Please see attached.

Regards,
Brian.Check-Email.xls
0
 
Matt PinkstonAuthor Commented:
AWESOME!!!!!!
0
 
redmondbCommented:
Thanks, pinkstonmp!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now