Return a Yes if a text is found within a cell

Hello,

I currently have the below formula to search for text of interest (A1) within each cell of a column (B6:B30).

=IF(ISERROR(MATCH(A1,$B$6:$B$30,0)),"NO","YES")

The formula works perfectly if there is only a single value in the cells. But not so well when the cell has multiple values separated by a comma.

For example:

Column B

X
Y
Z
T, X, Y, Z

It would return a "Yes" for X, Y, and Z because those are found individually. However, T will appear as a "No", because it is found within a cell that is separated by commas.

Any suggestions on how I can modify this formula?

I look forward to hearing from you, and thank all responses in advance.

Merry Christmas!

One way for sub string search ..
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(A1,$B$6:$B$30)))>0,"YES","NO")
------------------------
Works? Wave it, hit the little star at the bottom left of my responses

Perfection. Thank you!

welcome, glad to hear