Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel function search | New Users to Excel | |||
Excel Search Function | Excel Discussion (Misc queries) | |||
Excel search function | Excel Discussion (Misc queries) | |||
excel search function | Excel Programming | |||
Excel search function | Excel Discussion (Misc queries) |