Thank you this helped a great deal however is their a way that I can include
in the formula that if one sheet has a christian name, eg Anna and the other
sheet has both christian and middle name, eg Anna Rose that this will show as
a match? Also to include this in matching address's???

Christie

"Max" wrote:

One way

Assuming first names and surnames are in cols A and B in both Sheet1/2
In Sheet1,
Put in C1, normal ENTER:
=IF(OR(A1="",B1=""),"",IF(ISNUMBER(MATCH(1,INDEX(( Sheet2!A$1:A$100=A1)*(Sheet2!B$1:B$100=B1),),0))," Y",""))
Copy down as far as required. Adapt the ranges to suit.

Pl press the YES buttons (like the ones below) in ALL responses which helped
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Christie" wrote:
now I want to see if both the first name and surname
I have on one sheet matches the names on the other sheet
and they are in seperate cells. How would I do this?