| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting value if another cell contains a specific word
Row | Collumn1 | newcollumn | 1 | Thoughts MN | MN | 2 | 120Agents target | target| 3 | Eldoradonet target | target | 4 | eBorkin target | target | 5 | Flightair NP | NP | 6 | Getcardshere target | target | 7 | NoMadic | | 8 | timetoeat target CONVER | target CONVER | 9 | 4usa default time | default time | Using the text in collumn1 i.e. "Thoughts MN" I need to create a new collumn that would insert values based upon specific words in collumn1. The above tries to show what I need. The function would need to insert the values into newcollumn if it matches a word in collumn1. the words are MN , target, NP, target CONVER, default time and a blank space Thanks for the help -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=517917 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| delete a cell if it contains specific word | Excel Discussion (Misc queries) | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| Inserting extra info into a cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
