View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Patrick Young Patrick Young is offline
external usenet poster
 
Posts: 7
Default Function Vlookup, Match or Index?

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