[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# How to place an X in a cell if the previous has Y or Z or T in MS Excel

Posted on 2013-10-23
Medium Priority
420 Views
Hello,

I want to place an X in cell B if cell A has text abc OR acb OR fgr.

I have have hunted high and low for a formula for this, but could find it.

Ho do you do that with a formula?

Thanks!
0
Question by:Brejinski
[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
• 3
• 3
• 2
• +1

LVL 18

Expert Comment

ID: 39595701
Combine the IF OR functions:

=IF(OR(A1="abc", A1="acb", A1="fgr"), "X", "")
0

Author Comment

ID: 39595713
Thanks, ThinkSpaceSolutions, but let me try to be clearer: in fact the text in cell A has a lot of other texts. It's like this: fddgdgdgdf abc fdfdf.
0

LVL 18

Expert Comment

ID: 39595721
Hi,

One way:

B1=IF(ISERR(FIND("abc",A1))+ISERR(FIND("acb",A1))+ISERR(FIND("fgr",A1))<3,"X","")

If you add more strings to look for, increase the '3' to '4' or however many you include.

FIND is case-sensitive, so use SEARCH instead if you want non-case-sensitive.

HTH,

Alan.
0

LVL 50

Expert Comment

ID: 39595726
Try using SEARCH like this

=IF(COUNT(SEARCH({"abc","acb","fgr"},A1)),"X","")

As Alan says, SEARCH is not case-sensitive. if you want case-sensitivity switch to FIND

regards, barry
0

LVL 18

Expert Comment

ID: 39595731
Barry's is better :-)

But do note the case-sensitive thing on FIND vs SEARCH.

Thanks,

Alan.
0

LVL 18

Expert Comment

ID: 39595746
Nice one Barry.
0

Author Comment

ID: 39595795
Still not working for me... Maybe because my Excel has another language. I am uploading the worksheet here to see if you guys can help a little bit more.

The "sentences" are in column A and the words I am searching in it are "Corsa" OR "Classic" OR "Celta".
18-COMPRA.xlsm
0

LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 39595813
So I put this version in B2 copied down

=IF(COUNT(SEARCH({"Corsa","Classic","Celta"},A2)),"X","")

see attached

regards, barry
18-COMPRA-barry.xlsm
0

Author Closing Comment

ID: 39595816
Great! Thank you very much!
0

LVL 18

Expert Comment

ID: 39595829
{Ignore - Posted in error}
0

## Featured Post

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing howâ€¦
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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formâ€¦
###### Suggested Courses
Course of the Month12 days, 15 hours left to enroll