Excel Formula - If Cell contains word and select it from a list?

S

springs

Hi all,

I have found the following formula which is place the word ticket int
the cell if the cell in A3 contains the word Selfserve.

=IF(ISNUMBER(SEARCH("*Selfserve*",A3)),"Ticket","")

Just wondering if there is another formula that can be used to pic
items off a list to save me having to enter different words in ever
cell to make them match.. as this kind of takes the use of the formul
away.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
IF(ISNUMBER question 0
Is it possible to match a cell's contents from a list ? 8
How to set up a conditinal formula w/letters vs numbers? 2
Index and match if field contains specific text in it 1
VLookup IF word in string exists within cell, use the word. 0
IF statement based on True/False that activates a certain list box 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top