Some sample posts would be:

Sheet one - Surname: Smith (A1), Christian name: Michael John
Sheet two - Surname: Smith (A1), Christian name: Michael

I would need the above to match even though sheet two does not have the
middle name.

I also have a sheet that has both surname and christian name in the one
cell, eg Smith Michael John (A1) and I need this to match the above sheets.

Hope this makes it easier to understand

Christie

"Max" wrote:

Could you post some sample data of what you have in Sheet1/2, and your
intents? Clearer that way
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Christie" wrote in message
...
This does work however I need it to pick up Y if both the christian and
the
surname is matches but the other worksheet has a middle name and the other
worksheet doesn't. At the moment with the formula you have given me it
picks
up if for eg brown and it would say Y to browne.
Is this possible.