I need to check if any text from column A appears in any cell on column B (partial or exact).
and if possible- mark the cells in some way.
for example in the screen shot- items in column A have a match (or partial match) on column B.

enter image description here

i tried: =IF(NOT(ISERROR(MATCH(A:A,B:B,0))), “Yes”, “”) but i only worked for same-row text.
also tried this one: =IF(NOT(ISERROR(MATCH(A1,$B$1:$B,0))), “Yes”, “”) – for C1 cell, and dragged it across the entirety of column C- it kinda works, but not in a convenient way