S
siddique
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
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