A Formula to search for three different text strings in 1 column

[Pingbat]

HI

I've got a spread sheet with text data. I need a formula to search for any instances of a text string "2017, 2018 or 2019" & get a FAIL output in the adjacent column.

I get success with the below formula but i just cant get / re work it to search for three different words, e.g. 2017 2018 or 2019.

=IF(OR(ISNUMBER(SEARCH("2017",A2)),ISNUMBER(SEARCH("2018",A2))),"FAIL","PASS")

vegas pool party closing 2017 FAIL vip pool party las vegas july 2018 FAIL vegas pool parties 2019 PASS <tbody> </tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Any advice welcome,
David

 

[Fluff]

How about
=IF(OR(ISNUMBER(SEARCH({"2017","2018","2019"},A2)),),"FAIL","PASS")

 

[Pingbat]

Fantastic It Works, bravissimo!!!!

 

[Fluff]

You're welcome & thanks for the feedback