Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting result of Index function | Excel Worksheet Functions | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
index / match function | Excel Worksheet Functions | |||
VLookup or Index Match ? | Excel Worksheet Functions |