Find Match

[mtapp2207]

I have a workbook with two sheets. I have names listed on sheet 1 in column A and names listed on sheet 2 in column A. I would like to find the matches. Any help is appreciated

Something like this.

Sheet 1		Sheet 2
Name		Name
Susan Patt		Michael Patt	Found
mary Smith		Susan Patt	Found
Michale Patt		Mary Jones

 

[Fluff]

How about

=IF(COUNTIFS(Sheet1!A:A,A2),"Match","No match")