| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text formula
Hi
I am trying to find out how should I proceed with the folowing problem. I have a group category of data in sheet 1 as folows: Sheet1 COLUMN A:A Group category PCM GLOBAL PURCHASING CMT GROUP NETWORK In sheet2 I have different charges that I need to sumarize, but the problem is, that descriptions can contain more information and I can't just simply use a vlookup formula. I need to apply a formula that will recognize group category in the text SHEET2 Description amount formula PCM AAAA AAAA AAAAA 111 =pcm AAA CMT AAAAA 223 =cmt AAAA GROUP NETWORK 2131 =group network ttttttt 654 =other Thanks in advance Eva |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
| Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Threaded Mode
