How to use multiple functions with multiple exceptions

**Microsoftnovice** · 12-03-2012, 10:45 AM

Ok so here's the deal. I'm developing a customer form with fill in the blanks for my job. The answer to a certain section is dependent upon the what is filled in. I used vlookup to calculate the section. For example.

if B25= 1 and E25 and H25=x and a specific number will result. it would be the same if E25=1 and the other 2 are x. Heres my problem: if B25=1 and E25=1 than it would be that specific +25,000 would be the result. if B25=1 and E25=2 than a specific number +42,000.

Excel keeps telling me that there are too many arguments. Is there anything else I can do to get this work? I have attached the section for someone to look at. On Sheet 2, the license cost is the price I need to integrate if the exception is in place the Thanks in advance

**TheExcelphile** · 12-03-2012, 10:55 AM

Hi there!

I've included the license cost into your formula in K5 of the sample workbook.

I hope this is what you were looking for.

On a side note, a word of advise... Don't merge cells. It messes up the worksheet.

Don't forget to click on the little star to the left of this post if you feel I helped!

**Microsoftnovice** · 12-03-2012, 12:23 PM

That did help a lot but I may have not explained it thoroughly. if B3=1 and E3=1 than the standard price would be the same for B3 and E3 would equal the license cost and then we add that. but that would change again if B3=1 and E3=2.

Thank you!

**TheExcelphile** · 12-03-2012, 01:15 PM

In that case, you could simply add two VLOOKUPs.

For example, the formula in B5 in your sample sheet would be:
=VLOOKUP(B3,Sheet2!A2:B6, 2, FALSE)+VLOOKUP(B3,Sheet2!D2:E6, 2, FALSE)

Don't forget to click on the little star to the left of this post if you feel I helped!