Search string in multiple cells

[cal1003]

I have a set of cells that have a value of letters in them, say "PM123" in cell D1. I want to compare that value to multiple cells, say in A1, B1 and C1, and see if it is in there.

However I want to search if it's partially in there, so if "PM123" is what i am looking for in cell D1, i want it to be found if it is in B1 as "ZZZPM123XXX", and the same true if it is cell A1 or C1...

Any ideas? i have tried find, iserror, if statements, none of which i can get to work with multiple cells, searching only part of the cell, and alpha chars.

Thanksin advance for any and all help!

[JBeaucaire]

Try this formula:

=ISNUMBER(MATCH("*" & D1 & "*", A1:C1, 0))

[rylo]

Hi

try

Please Login or Register  to view this content.

rylo

[cal1003]

Thank you very much JB and Rylo!!!! Both of your formulas worked! JB yours returns a true/false, and Rylo yours returns a 1/0 definition. BOTH will come in very handy for this situation! thank you again both for your time!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.