I know this is simple, as usual I cannot figure it out and my search here didn't return helpful answers (prob. using wrong terminology).

I am working in Excel 2010. I have two spreadsheets. One column on each has matching information, but all other columns are different on each. I am trying to compare the two tables and, based on the matching data, mark off the rows that match on both; all the rest of the rows I don't care about). I need Excel to search both sheets and, if there are matches, return simply an X in a blank column on Report 1. Here's a sample:


REPORT 1:
A B C D E <--------this is the column where I assume the formula must go
Name Initials Job Title Home City where I want the check-offs to show
1 John Smith JBS Sales Manager Chicago X
2 Mike Jones MLJ HR Director Miami
3 Susan Drew SDD Accounting Clerk New York X

REPORT 2:
A B C D
1 Territory Phone # Initials Hire Date
2 Southeast 999-123-4567 SDD June 1999
3 Pacific NW 999-987-6543 BIW April 2001
New England 999-102-8374 JBS January 1984


[It goes without saying that the two spreadsheets contain hundreds of rows and columns, I don't want to have to manually look down the two Initials columns to find matches.]

I hope I've explained it clearly. If possible, can you not only explain but provide the formula itself that I can copy-paste.

As I said above, I think this is simple and I will feel dumb for having had to ask.

Thanks,
Cindi