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
Bookmarks