Multiple IF arguments in single cell

Hey all,

Now I have been searching and searching but cannot seem to locate a resolution to my current Excel issue. So hopefully I can find someone here that knows how to resolve this issue.

I need to create a formula with 8+ arguments in a single cell, which I know cannot be done. SO, I started to use LOOKUP, which just confused me beyond belief.

Here is what I have:

I have a various dates (14 total dates) in cells C2 through C15.
I have dollar amounts in cells D2 through D15.
I have the days of the month in G2 through G31.

What I am aiming for:

A formula that will take G2 and search through my various dates (C2 - C15). IF G2 = one of the dates, THEN it will equal the D cell next to it. And make G3 do the same, and so on. Here is my formula that limits 8 arguments: =IF(G1=C2,D2,IF(G1=D3,C3,IF(G1=D4=C4,IF(G1=D5,C5,0))))

I know there has to be an easier way to do this AND allows me to check all my 14 dates in the C column.

Due Date Amount Date Amount
1-Oct $110.00 1-Oct $110.00
11-Oct $50.00 2-Oct
3-Oct $83.69 3-Oct
1-Nov $850.00 4-Oct
16-Oct $20.00 5-Oct
21-Oct $20.00 6-Oct
27-Oct $40.00 7-Oct
23-Oct $19.99 8-Oct
20-Oct $35.00 9-Oct
14-Oct $26.29 10-Oct