Hello Patrick,

It would help if you explained a little more. Right now we only have what
information you are attempting to use to return a value. This does not tell
us how your data is structured, which doesn't really allow us to give you a
working solution. Try explaining in greater detail how your data is setup,
where you are wanting to put this formula and what the desired results
should be.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"Patrick Young" wrote in message
...


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