Solved

Search cell for multi strings

Posted on 2016-08-18
3
29 Views
Last Modified: 2016-08-18
I need to search cell a2 for the following text

POBO
ROBO
VA
Virtual Accounts

If the cell contains any of those four texts, return "Found"

Many thanks
0
Comment
Question by:Seamus2626
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 41760996
assuming the cell you are looking into is A1 then use the following formula.   it is case sensitive , if you do not want case sensitive then replace FIND with SEARCH

=IF(SUMPRODUCT(--ISNUMBER(FIND({"POBO","ROBO","VA","Virtual","Accounts"},A1)))>0,"Found","Not Found")

not case sensitive then
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"POBO","ROBO","VA","Virtual","Accounts"},A1)))>0,"Found","Not Found")
0
 

Author Closing Comment

by:Seamus2626
ID: 41761168
Thanks Professor!
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41761191
you are welcome seasmus2626. i am glad i was able to help
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Suggested Solutions

Title # Comments Views Activity
how to reset cell styles? 15 25
Automatically report prepared in excel by VBA 5 34
A Table within a User Form 24 42
remove extra space at end of cell 12 31
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
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…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

809 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