| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF or SUMIF to bring back text?
sounds like you need VLOOKUP
"Valerie" wrote: I am trying to match departments which have two different titles. For example, there are 50 departments that are futher classified into 150 sub-departments. I do have the data showing departments and their corresponding sub-departments in two columns. On another sheet there are only sub-departments and I need to assign the corresponding department name. I have tried IF and SumIf but neither works. Basically, I need a formula to match the text and bring back the text for the sub-department. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bring Back DBF! The GIS Industry uses it! | Excel Discussion (Misc queries) | |||
| Bring back .dbf in Excel | Excel Discussion (Misc queries) | |||
| Bring Back Qualified Sum from another WB | Excel Worksheet Functions | |||
| Bring back the old help format! | Excel Worksheet Functions | |||
| Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
Threaded Mode
