| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Formula - If Cell contains word and select it from a list?
Hi all,
I have found the following formula which is place the word ticket into 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 pick items off a list to save me having to enter different words in every cell to make them match.. as this kind of takes the use of the formula away.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to select the last non-blank cell in a list | Excel Discussion (Misc queries) | |||
| How to create a bulleted list within a cell in excel (as in Word) | New Users to Excel | |||
| How can I copy a list from word into a single cell in excel | Excel Discussion (Misc queries) | |||
| can i select from list by typing first letter of word? | Excel Discussion (Misc queries) | |||
| Find a certain word in excel and select the cell | Excel Programming | |||
Linear Mode
