Jhovyn Marcos
asked on
Excel Formula - How to search text that contains certain value in multiple columns?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here is another approach:
Jhovyn_SearchAndUpdateStatus.xlsx
=IF(OR(ISNUMBER(SEARCH("PO",A2)),B2="0MX"),"Approved","Disapproved")
Please find attached with all the options...Jhovyn_SearchAndUpdateStatus.xlsx
ASKER
Wow! All of you are correct! Thank you guys you helped me a lot :D
Open in new window
* I am assuming Size may be like " 0MX - 1MX" or "Size 0MX". Thats why I used seacrh here on this column as well..