Multiple SEARCH/FIND on one cell

P

Pilar Morales

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search multiple text in one string 7
Find and Replace 6
Create if partial match then copy and paste data from one cell to another 1
Column range to search from a source workbook and then copy/paste 0
Search multiple worksheets and return value to main worksheet 7
Find word copy and paste 0
find multiple or by different words 3
Search a database with multiple strings? 7

Top