So I want to search in a cell if it contains one of the following words: yearly, monthly, quarterly. If it finds yearly, I would want the formula to return YTD, if it finds Monthly I would want to return MTD, and if it finds quarterly I would want to return QTD.
I thought it would be a simple nested if, but maybe I'm wrong?
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
Or...
=iferror(LOOKUP(1000,SEARCH({"Yearly","Monthly","Quarterly"},A2),{"YTD","MTD","QTD"}),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Works perfectly! Thanks so much!Originally Posted by Glenn Kennedy
You're welcome and thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks