Find Matching Value

[infinitysales]

I need a formula to check B2 against all of column C. If there is a match anywhere in column C then I need a "Y" to be entered. I had entered the below, only it doesn't work if the matching items are not on the same line. Any help is greatly appreciated!

Please Login or Register  to view this content.

I have attached a sample.

[DonkeyOte]

Based on my interpretation of requirements

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[infinitysales]

Perfect! Thank you so very much!