isnumber multiple criteria.

[cbanks]

=IF(ISNUMBER(SEARCH("WARN",J2)),"Warning","") is what i have.


but i also want it to search column n, and if the column n contains psnap, i
want it to put sales instead of warning. thanks a ton for any help

[Bob Phillips]

Do you mean

=IF(ISNUMBER(SEARCH("psnap",N2)),"Sales,IF(ISNUMBER(SEARCH("WARN",J2)),"Warn
ing",""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cbanks" <[email protected]> wrote in message
news:[email protected]...
> =IF(ISNUMBER(SEARCH("WARN",J2)),"Warning","") is what i have.
>
>
> but i also want it to search column n, and if the column n contains psnap,
i
> want it to put sales instead of warning. thanks a ton for any help

[Bob Phillips]

Sorry, type

=IF(ISNUMBER(SEARCH("psnap",N2)),"Sales",
IF(ISNUMBER(SEARCH("WARN",J2)),"Warning",""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Phillips" <[email protected]> wrote in message
news:u%[email protected]...
> Do you mean
>
>
=IF(ISNUMBER(SEARCH("psnap",N2)),"Sales,IF(ISNUMBER(SEARCH("WARN",J2)),"Warn
> ing",""))
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "cbanks" <[email protected]> wrote in message
> news:[email protected]...
> > =IF(ISNUMBER(SEARCH("WARN",J2)),"Warning","") is what i have.
> >
> >
> > but i also want it to search column n, and if the column n contains
psnap,
> i
> > want it to put sales instead of warning. thanks a ton for any help
>
>