View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
siddique siddique is offline
external usenet poster
 
Posts: 1
Default Search function in Excel

Search function
I need a help with the search function in Excel one or more text
strings

Example

cell B3 contains an address 1560 main road Montreal Quebec Canada

I would like such result to be True if either Montreal or Quebec or
both found in the D3 cell

I tried the two search formula but it does not work, both formula
looks for both conditions

=AND(SEARCH("montreal",B3),SEARCH("quebec",B3))

=OR(AND(SEARCH("montreal",B3),SEARCH("quebec",B3)) )

Any help would be appreciated