Hi All,

I'm looking for a function that can check to see if a cell contains specific text. For Example:

I have many cell that contain some, all, or none of the following 4-character text:
|C180|, |D410|, |S531|, |T844|
and I would like to know if, let's say D410, is contained in a certain cell. I will be checking for this in an array.

I also have another quick question. Is sumproduct or sum(if(.....)) quicker if they are both checking the same amount of criteria?

Thank you in advance,

Jason