yes, exactly. It worked perfectly. Thank you

"Atreides" wrote:

Like this?:

Mastersheet
A B
1 aaa Y
2 bbb Y
3 ccc

Sheet 2
A
1 aaa
2 bbb

The formula in B1 would be:

=IF(ISNUMBER(MATCH(A1,Sheet2!$A$1:$A$2,0)),"Y","")

And so on...

Hope this helps

- Atreides