Multiple IF arguments in single cell

**rideahonda** · 10-04-2010, 09:59 PM

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

**SDruley** · 10-04-2010, 10:47 PM

Possible solution attached.

**arthurbr** · 10-05-2010, 02:18 AM

If the due dates are unique another solution

=IF(COUNTIF($C$2:$C$11,E2),VLOOKUP(E2,$C$2:$D$11,2,FALSE),"")

Or eventually a Pivot Table if many due dates are the same

**SDruley** · 10-05-2010, 08:56 AM

rideahonda,

arthurbr is so correct. In the spreadsheet I sent you the original formula is only good for one occurrence of an amount due for a specific date.

steve

**rideahonda** · 10-05-2010, 05:30 PM

Thank you SDruly and arthurbr! Both of your answer are great. I would have never been able to get this, so thank you again. If I can figure out how to, I will mark this solved so others can benefit from your knowledge!!