Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Search Criteria

Posted on 2014-03-30
Medium Priority
167 Views
I have a spreadsheet that in column A, will have a number of things listed in it. I want to have column D show up as either a laptop or a desktop, based on the values in column A. The equation for column D at the moment, reads:

=IFERROR(IF(SEARCH("blah",A2),"Laptop",""),"Desktop")

The logic says that if it isn't a match, say it is a Desktop. This is fine, but I need to be able to search for any of a number of terms, and if there is no match, then say it is a desktop. So for instance, how does one change the above query to match for any of the following (but not all):

blah
blah2
blah3

is there a way to do a search for any one of the following?
0
Question by:stakor
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

Author Comment

ID: 39965695
I see this might be a possible solution, but am uncertain how to join the two.

=OR(first condition, second condition, …, etc.)
0

Accepted Solution

stakor earned 0 total points
ID: 39965845
=IF(SUM(COUNTIF(A2,"*" &{"blah1";"blah2";"blah3"}& "*"))>0,"laptop","desktop")
0

## Featured Post

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month10 days, 6 hours left to enroll