I have attached a sample workbook with what I think you want?
Basically, you want to show yes for any matches with Z, is that right? If this is right, look at the match with Z? calculation.
Hope this helps! If not, maybe you can use the data I used and go into more detail about the desired outcome?
match with Z.twbx.zip 11.8 KB
You can call me X!
Thanks for that, I will try it out.