Formula - If find 3 possible words within a cell, return the word found?

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.

Originally Posted by Glenn Kennedy

Or...

=iferror(LOOKUP(1000,SEARCH({"Yearly","Monthly","Quarterly"},A2),{"YTD","MTD","QTD"}),"")

Works perfectly! Thanks so much!