search for multiple text strings within an IF statment

**Radman** · 09-16-2008, 05:01 PM

Hi, I am having a problem finding multiple text values in an "if" statement.
what I want to do is check for four different text strings in a cell for the logical test.
For example if the cell contains 'MDF','PB','PART', OR 'PLAT', I want to return "MACHINE1" otherwise return "MACHINE2".
I can't seem to get the FIND ISNUMBER and OR statements to work together.
Anyone have any ideas for me?
Thanks a bunch,

**VBA Noob** · 09-16-2008, 05:29 PM

Maybe

=IF(SUM(COUNTIF(A1,{"*MDF*","*PB*","*PART*"}))>0,"Machine1","Machine2")

VBA Noob

**Radman** · 09-16-2008, 06:50 PM

That did it! Thanks a lot for the quick reply!

**ddazet** · 09-30-2013, 01:58 PM

Thanks! This works perfectly!

search for multiple text strings within an IF statment

LinkBack

Thread Tools

Rate This Thread

Display

search for multiple text strings within an IF statment

Thanks

Re: search for multiple text strings within an IF statment

Thread Information

Users Browsing this Thread

Similar Threads

search and select rows on user entered text

extracting text strings from a cell

Keyword Search on Strings of Text

Extracting strings of text from Columns of data(text)

Bookmarks

Bookmarks

Posting Permissions