> ... need the opposite. want to look for the word Warranty item.

Try:

=IF(O31="","",IF(AND(TRIM(B31)<>"Closed",ISNUMBER(SEARCH("Warranty
item",S31))),O31+ROW()/10^10,""))

> Also, can anyone recommend a good Excel book.

Try browsing the comprehensive list in Debra's page at:
http://www.contextures.com/xlbooks.html

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" <royokinawa@discussions.microsoft.com> wrote in message
news:DC050660-59FC-4B72-B0E8-567C53E735DA@microsoft.com...
> I was provided this formula to not look for the word Repair Clin:
>
> =IF(O31="","",IF(AND(TRIM(B31)<>"Closed",NOT(ISNUMBER(SEARCH("Repair
> Clin",S31)))), O31+ROW()/10^10,""))
>
> Now, I need the opposite. I want it to look for the word Warranty item.
>
> Also, can anyone recommend a good Excel book.
>
> Thanks