isnumber query

[fry]

Hi All

Can someone tell me how to have 2 options using isnumber.

I'm using ISNUMBER(SEARCH("SUBMITTED",N156)) but I'd like to have "SUPPLY" & "SUBMITTED"

Is this possible??

Thanks

 

[barry houdini]

If you include the search terms in Z1 and Z2 as Richard suggests then you only need

=COUNT(SEARCH(Z1:Z2,N156))

 

[Aladin Akyurek]

You could get away with:

=SEARCH(N156,"SUPPLY,SUBMITTED")

 

[fry]

Thanks again guys, both very neat indeed but couldn't get

SEARCH(N156,"SUPPLY,SUBMITTED") to work for some reason

 

[Richard Schollar]

Aladin's formula will only work if cell N156 only contains Supply or Submitted (or both as "Supply, Submitted"). I assumed as you were using Search that the cell could potentially contain plenty of additional text as well as the sought for words.

 

[fry]

Hi Richard

Yes you're right it could contain other text but I did try Aladin's example with just the word itself and couldn't get it to work.

I've ended up using your separated out example so thanks again for that.