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.