| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF cell contains certain text return value
I have a row containing various text including the words 'Check' &
'Checking'; in a separate row I would like to identify all the cells which include 'Check' or 'Checking' and return the text "Checking" if it contains either 'Check' or 'Checking' or "Doing" if it doesn't. Hope this makes sense? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
| return the reference of a cell with certain text in it | Excel Discussion (Misc queries) | |||
| Return cell reference as text | Excel Discussion (Misc queries) | |||
| lookup a text cell and return text | Excel Discussion (Misc queries) | |||
| How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
![Eán[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
