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?

=IF(FIND("*yearly*",A8),"[YTD]",IF(FIND("*monthly*",A8),"[MTD]",IF(FIND("*quarterly*",A8),"[QTD]")))