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?