How do I search for more than one text character in one cell?

D

Dolores

I have a column with different names in one row. And one cell where it could
be that one of the names of the column can be shown. My goal is to find a way
how to search for this one word in the cell...
I've tried... but I got an error and I don't know which one!

e.g:

MATCH(TRUE,ISNUMBER(SEARCH("*"&J11&"*","*"&A1:A4&"*")),0)

Thanks for any help in andvance!
 

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 more than one character 2
How can I search for more than one text character in a cell? 3
Evaluate Multiple Cells for any Value 1
Search cell value in same column 3
=MATCH with nested arrays assistance needed 0
Hyperlinks with lookups 0
How to sum more than 30 cells 9
Create if partial match then copy and paste data from one cell to another 1

Top