isnumber multiple criteria.
 

=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

isnumber multiple criteria.
 

Do you mean

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cbanks" wrote in message
...
=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

isnumber multiple criteria.
 

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" wrote in message
...
Do you mean


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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cbanks" wrote in message
...
=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