Solved

I need a formula that I can search for the existance of one of multiple strings in a cell

Posted on 2011-09-05
3
212 Views
Last Modified: 2012-05-12
I want to search wether a cell contains either "office" or "excel" or "access".
The formula should also give a succes when multiple of the strings are present in the cell.
0
Comment
Question by:itbabe
  • 2
3 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36484813
=COUNT(SEARCH({"Office","Excel","Access"},A1))>0

for example.
0
 

Author Comment

by:itbabe
ID: 36488224
When I paste this exact formula in excel I get a message that it contains an error.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 36488233
If you normally use a semicolon in formulas rather than a comma, you need:

=COUNT(SEARCH({"Office";"Excel";"Access"};A1))>0

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question