=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
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks