Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
91
Views
Topic starter
Hi Mynda,
Thanks for posting this! I tried to search for multiple texts in one cell. example:
cell A1 = red, A2 = blue, A3 = green ; I created named range 'list' which is $A$1:$A$3
cell B1 = car is blue
formulae: SEARCH(list,B1) results in #value
FIND(list,B1) results in #value
Attached is excel.
Thanks,
Atul
Posted : 28/05/2019 5:17 pm
Hello,
Sorry, but no file is attached.
Seems to me that you want to do something like this. https://www.myonlinetraininghub.com/excel-search-string-for-a-list-of-words
Posted : 29/05/2019 1:01 am
