| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Entry Formula based on IF or something Better
Hi All,
I have a situation where I need to fill Column B with Text Depending on what Text is in Column A eg Column A Column B 1 GREAPPLES GREEN Products 2 PEARSGREEN GREEN Products 3 GreenGarbage GREEN Products In other words I would be using GRE as the condition in Col A for a product to classed as GREEN Products I would be grateful if someone can point me in the right direction. Thank you Edwin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to fill a cell based on an entry in one of two worksheets | Excel Worksheet Functions | |||
| Excel formula timestamp for a data entry of a referenced cell | Excel Worksheet Functions | |||
| Display data from cells based on a formula | Excel Discussion (Misc queries) | |||
| Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Threaded Mode
