Hello,
I am working on a beast of a document to track customer requests that multiple people look at, and I want to make a formula that autopopulates a column with instructions on what people should do when certain criteria are met.
The document contains the following columns that I need to work off of (see EXAMPLE.xlsx which illustrates better):
Column A: The name of the form submitted (there are 3 different ones: "Delete", "Do Not Sell", "Both")
Column B: If the person exists in a database ("yes" or "no")
Column C: The person's current order status ("Active", "Expired", "Cancelled", "Credit Pending" and "N/A")
So I'm looking for a formula that can do the following: If a person submitted the "Delete" form, is "Yes" in the database, and has a status of "Expire" then the return text should be "Delete customer".
I should note that sometimes the text doesn't always match. For instance, an order status might say "Active on X product". Is there a function that looks for words within a string?
I'd have to tweak for the other criteria but having the above should be enough for me to start.
Thanks in advance.
Bookmarks