XLSX lookup value in cell

I have a list of 300 items where the Ticket Title column has various descriptions. I have created a column which I want to do a search against each adjacent Ticket Title field (same row) for existence of "SQL", with no quotes. I want it to return a 1 for EXISTS and 0 for NOT EXISTS. can you help me form the filter statement?
Thank you!
JohnD
LVL 1
John DarbyPMAsked:
Who is Participating?
 
Steven HarrisConnect With a Mentor PresidentCommented:
Disregard the last post, I see what you are looking for now.

In cell O2:
=IF(ISNUMBER(SEARCH("SQL",B2)),"1", "0")

Open in new window


Copy down.

Let me know if that is what you were looking for.
0
 
Steven HarrisPresidentCommented:
Can you upload a sample of the data?
0
 
John DarbyPMAuthor Commented:
Surely can...
samplesheet.xlsx
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Steven HarrisPresidentCommented:
Now that we can see what you see:

What is the exact criteria you are looking for?  How do you know which word you will be searching for for example?
0
 
John DarbyPMAuthor Commented:
Works like a gem; thank you!
0
 
Steven HarrisPresidentCommented:
Glad to have helped!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.