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")

[TABLE="width: 614"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]vegas pool party closing 2017[/TD]
[TD]FAIL[/TD]
[/TR]
[TR]
[TD]vip pool party las vegas july 2018[/TD]
[TD]FAIL[/TD]
[/TR]
[TR]
[TD]vegas pool parties 2019[/TD]
[TD]PASS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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