Forumla to return a price based on three conditions:

Hello all,

I am sort of facing a dilemma. At the end of every month, I have to prepare a billing file that totals all activity for each one of our clients. Unfortunately, this process takes me three days to complete because of all the data that is required and then reviewed.

I have managed to input a few formulas that have made this process a little easier for me; however, I cannot figure out how to create a formula that will generate a price based on account number, contract, and description.

Here is the tricky part for me:

Each one of our clients are on a contract.
Each of the contracts have different prices for the products we offer.

For example:
Clients
001 - Client 1 - Contract 2
002 - Client 2 - Contract 3
003 - Client 3 - Contract 1

Contract 1
Product 1: 2.00
Product 2: 4.00
Product 3: 6.00

Contract 2
Product 1: 3.00
Product 2: 6.00
Product 3: 9.00

In reference to the information included on the sample sheets:

- Account number is entered in C2
- Description is entered in E2; the format for the description (the data being billed) is date-company-product type(1, 2, or 3)
- Price to be generated in R2

Issue in play: C2 001 (Client 1 account number) that is on Contract 2 is being billed in E2 with date-company-product type 3 (product type 3 for 001) then potentially priced in R2 (9.00) automatically.

Can anyone help me with a formula that allows me to enter the account number, matching the contract type, to generate the correct pricing based on the product being billed in R2?

Thanks so much for the help everyone!

I hope I did this right!>.<