Searching for text

[Trip Poly]

Max helped first maybe again?

I have a search that I want it to look for two separate values in the
same search string.

the search is embedded in an if statement like so...

=IF(ISBLANK(B3),"",IF(ISERROR(SEARCH("11",B3)),"",ROW()))

Search is looking for 11 right now and I also want it to look for 12.

I have tried several different scenarios but can not seem to get it to
work.

Is this possible to do?

Thanks
C

 

[Bernie Deitrick]

C,

=IF(ISBLANK(B3),"",IF(OR(ISERROR(SEARCH("11",B3)),ISERROR(SEARCH("12",B3))),
"",ROW()))

HTH,
Bernie
MS Excel MVP

 

[Trip Poly]

Bernie,

Thanks for the help...with that I got what I needed.

C