View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Help With Searching For Strings In Part Numbers

On Jun 21, 9:18*am, "tb" wrote:
I am using Microsoft Excel 2000.

I have a spreadsheet with many, many part numbers in Column A. *There
are no duplicate part numbers.

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".

So, I built the following formula (which obviously does not work!!):
=IF(ISERR(SEARCH(OR("1K0PR","1K0SI","1K0VA","1K0VR "),A1,1)),"","X")

What am I doing wrong?
--
tb


'=IF(COUNT(SEARCH({"1KOVR","1KOSI"},B28)),"X","")