Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sorry, I am sending this again, as the format gots messed up.
Please help me write the function that would match the Month and the Sales to give me the amount of Commission for each combination of Month and Sales Value. Thanks, Patrick Month Sales Commission May-05 - - May-05 $ 297,409 $600 May-05 $ 1,000,000 $833 Jun-05 - - Jun-05 $ 330,515 $800 Jun-05 $ 1,500,000 $900 Jul-05 - - Jul-05 $ 298,390 $500 Jul-05 $ 1,700,000 $ 1500 Aug-05 - - Aug-05 $ 341,568 $400 Aug-05 $ 1,900,000 $600 Sep-05 - - Sep-05 $ 319,376 $700 Sep-05 $ 2,000,000 $1500 Oct-05 - - Oct-05 $ 379,096 $200 Oct-05 $ 1,000,000 $1800 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup or index match function | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
Function Vlookup, Match or Index? | Excel Programming | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions |