| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple SEARCH/FIND on one cell
This is what I have on D21: (comments in [])
=IFERROR(IF(SEARCH(OR($E$3,$F$3,$G$3),E21),$D$3,[continue with next 45 words]),$D$14[catchAll]) OR- Doesn't work on multiple search or find. Not sure how to do it in VBA. Brain freeze Help..please :) Different/faster/better solutions also welcome. Thanks, Pilar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Search Column - Find Multiple Entries - Sum Then Delete to Single Entry | Excel Programming | |||
| Multiple Find/Search Criterias | Excel Programming | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| multiple search criteria to find and copy from sheet1 and paste into sheet2 | Excel Programming | |||
Linear Mode
