Hi, everyone,

I have 5 keywords in cells A1:A5,

Quarter
Semi
Final
Regular
Interim

Now I want to test if cell B1 contains one of the 5 keywords. Cell B1 is a text which is something like FinalABC. Because FinalABC contains the keyword Final, it should return true.

Is it possible to test this in Excel? Otherwise, I have to do this in VBA.