I need a formula to find out if the text in each cell of a column is contained in any cell in another column. If it is, show "Yes" or "True". It is kind of confusing so I attached an excel document I whipped up as an example. As you can see in the below picture, I need excel to check if B2 text is contained in A2 through A5. Since A2 contained "100100" it marked it as a "Yes" is cell C2. I would like the ability to put the formula in C2 then drag it down to C3, C4, C5, etc and have it reference B3, B4, B5 cells while still searching A2 through A5 for each one. The formula that works is >>>> =IF(COUNTIF(A2:A6,"*100100
,"Yes") <<<< but I have to go in and manually type the number I would like to search for instead of just referencing cell B2. I know this sounds confusing but any assistance is appreciated.