=IF(AND(ISNA(A1),ISNA(B1)),"Check",IF(ISNA(A1),B1, IF(ISNA(B1),A1,IF(A1=B1,A1
,"Check"))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"EstherJ" wrote in message
...
I need an if formula or similar which will look at the values in columns A
and B and bring back the results as shown. I can't seem to cover all
scenarios.

Thanks,

Esther
A B Result

1 X Y Check
2 X X X
3 #N/A #N/A Check
4 #N/A X X
5 Y #N/A Y