This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I had to take a career break for several years to take care of my sister's kids. I was finally offered a job in accounting/finance but excel skills are rusty. I am learning but stuck on this one: I am checking a column full of emails and if the emails have the following text within their address, I am to return the term "Test order" in another column. Here is my formula:
=IFERROR(IFS(L2="*@test.axxxxxxxx.com","Test Order",L2="*@test.com","Test Order",L2="Test@*","Test Order",L2="*[[email protected]](mailto:[email protected])","Test Order"),0)
for some reason formula isnt working. But i would also like help if writing this more efficiently with maybe a better formula. Thanks
Subreddit
Post Details
- Posted
- 10 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...