Hi Ron - that seems to net me the same thing - it appears to be looking at
the cell and not the text within the cell? I have been testing with data I
know is in both sheets and I cannot return any good info.

(A1) contains ADVAN & (B434) contains ADVANTAGE, what do I put in (C1) to
let me know that (B434) exists?

Ray


"Ron Rosenfeld" wrote:



Some variation of:

=IF(ISERR(SEARCH(A1,'Master List'!$A$1:$A$100)),
"Not on Master List","ON master list")

Should let you search an array to see if a particular string is present.

For A1, substitute the string you are searching for.


--ron