Forum

Notifications
Clear all

Searching multiple texts in one cell

2 Posts
2 Users
0 Reactions
166 Views
(@atulforum)
Posts: 1
New Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 973
Prominent Member
 

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
Share: