View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cbanks
 
Posts: n/a
Default 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