I actually used the following and got what I expected Thanks
'=+IF(COUNT(SEARCH($L$1:$N$1,S496)),"UPDATED"," ")
--
JPS


"Ron Coderre" wrote:

A variation...

=IF(COUNT(INDEX(SEARCH(rng,C1),0)),"UPDATED","")

--------------------------

Best Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Ron Rosenfeld" wrote in message
...
On Thu, 13 Mar 2008 01:03:01 -0700, JPS
wrote:

In Excel I need to character search a cell and determine if one of 3 text
strings, 01-08, 08-07, 27B can be found anywhere in the cell, if one of
them
are found I need UPDATED to show in the results cell, if none of then are
found the results cell will be blank.


=IF(SUMPRODUCT(--ISNUMBER(SEARCH(rng,C1))),"UPDATED","")

where rng is a range of cells containing the text strings you wish to
search
for. C1 is the cell being searched.
--ron