Countifs unique values based on two criteria

[shaz0503]

All

My first post....

I have a data set that contains various records against unique identifier. I need to be able to return a vaule of "Y" instead of the count - indicating that the unqiue identifer has at least one record with a specified value.

I have tried countifs, countifs & frequency but can't seem to figure it out.

The countifs formula is =COUNTIFS(CASS_Staff_Submission!$D:$D,Sheet2!$D:$D,CASS_Staff_Submission!$K:$K,Sheet2!CH$1) and currently returns a count of 3 - I need to have a "Y" returned..

I have attached a very small example

any thoughts appreciated

Shaz0503