vlookup, match, index

Using Excel 2003 and am trying to do a calculation by customer, by service type. Attached is the workbook and I've tried numerous ways to do this.

On the revenue calculation worksheet, I am tryng to calculate the type of service minutes from the data retrieve worksheet, multipled by the service rate on the rate table for the specifc type of minute by customer.
I'd like to build it as a vlookup by customer and then by service type, but have run into difficulty.

Any help would be appreciated

In DataRetrieve!D2, paste this in the formula bar:

=C2 * INDEX('Rate Tbl'!C:C, MATCH(A2 & B2, 'Rate Tbl'!A1:A100 & 'Rate Tbl'!B1:B100, 0) )

Don't press Enter; instead, press and hold the Ctrl ad Shif keys, and then press Enter.

Then copy down.

shg's solution works slightly better with

=C2 * INDEX('Rate Tbl'!C:C, MATCH(A2 & B2, 'Rate Tbl'!A$1:A$100 & 'Rate Tbl'!B$1:B$100, 0) )

For a one step approach in the revenue calculation sheet, use this ugly formula in B2 to B8

=SUMPRODUCT(--('Data Retrieve'!$A$1:$A$300='Revenue Calculation'!$A$1),--('Data Retrieve'!$B$1:$B$300='Revenue Calculation'!A2),'Data Retrieve'!$C$1:$C$300)*SUMPRODUCT(--('Rate Tbl'!$A$1:$A$300='Revenue Calculation'!$A$1),--('Rate Tbl'!$B$1:$B$300='Revenue Calculation'!A2),'Rate Tbl'!$C$1:$C$300)

Copy to B11 and adjust the red bits to be $A$10 instead of $A$1, then in B20 and following, use $A$19, etc.

shg's solution works slightly better with ...

My bad, thank you, teylin.