I have three statements:
=IF(ISNUMBER(SEARCH($ET$2,B2)),B2,CONCATENATE("NA ",B2))
But I want to do
=IF(ISNUMBER(SEARCH($ET$2 **OR** $ET$3 **OR** $ET$4, B2,CONCATENATE("NA ",B2))
how could this be accomplished in Excel?
or could I instead nest these two (which I have tried, but had no luck)
=IF(ISNUMBER(SEARCH($ET$2,B2)),B2,CONCATENATE("NA ",B2))
and
=IF(ISNUMBER(SEARCH($ET$2,B2)),B2,CONCATENATE("NA ",B3))