Look for Three Text Strings

[dparteka]

I have this formula that looks for "PW" and displays the line in Sheet 1 if it’s present. I'm looking to add maybe an OR statement so it looks for "PW" & "DW" & "SPE"... if a line has any one of these then it's displayed in sheet 1, if there are none then it is not displayed. Any help will be greatly appreciated, thank you.

=IFERROR(IF(SEARCH("PW",'Table 1'!A2,1),'Table 1'!A2),"")

 

[bosco_yip]

Maybe........

=IF(OR(ISNUMBER(FIND({"PW","DW","SPE"},'Table 1'!A2,1))),'Table 1'!A2,"")

Regards

 

[dparteka]

Very nice... thank you so much

 

[Khalid NGO]

Hi,

One more:

=IF(SUM(COUNTIF('Table 1'!A2,"*"&{"PW","DW","SPE"}&"*")),'Table 1'!A2,"")

Regards,

 

[dparteka]

Awesome, thank you Khalid