Hi,

Am Tue, 21 Jun 2011 14:18:01 +0000 (UTC) schrieb tb:

What I want to do is create a formula that will put an "X" in Column B
of a part number if one of the following strings is included in the
part numbers. (A part number will not have more than one of these
strings.)

1K0PR
1K0SI
1K0VA
1K0VR

For instance, if the part number were 1C014C014A0000D006, then there
would be no "X" in Column B because none of the above strings is
embedded in the part number. On the other hand, if the part number
were 1Z071K0VRKV0GS000AUTOM then there should be an "X" in column B
because it includes the string "1K0VR".

try:
=IF(COUNT(SEARCH({"1K0PR";"1K0SI";"1K0VA";"1K0VR"} ,A1))0,"X","")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2