Index formula with multiple match criteria (inc min)

Hello,

I have an index formula which I want to output four (4) different matches/results based on Code letters, (the first if statement just states the correct column based on person)

=IF($E4=1,MIN(INDEX($P$4:$P$6,MATCH(F4,$O$4:$O$6))*$C4*$G4,$H$23:$H$90),"")

This is currently working on taking the quote of an item, giving a result based on percentage & then giving an additional final result based on a item or other limit, using the min formula

The first is percentage based up-to the limits e.g C4*G4*P4 or the limits of H23:H90 (whichever is less) Code A

The second is percentage based up-to the limit e.g C4*G4*P5,C4*H4 or H23:H90 (whichever is less) Code B

The third is $ based up-to the limits, e.g C4*H4 or H23:H90 (whichever is less) Code C

The fourth is percentage based up-to a set dollar amount e.g C4*G4*P4, C4*Q7 or H23:H90 (whichever is less) Code D

I am unsure how to create the four match formulas to do this, ensure that the benefits (I4:M15) cannot be more than the remaining balances in (I23:I90) as the rows calculate & reduce the remaining balances (as in if the remaining balance is zero then the benefits must be zero) as data is entered in rows C4:F15 & there is no more benefits left

The other thing I wanted to do was to be able to setup a user entry form box to enter the limits (for the calculations) from H23:H90 in cell O2 instead of scrolling down to them & entering the limits

Thank you

Duplicate of thread http://www.excelforum.com/excel-prog...h-formula.html

As per forum rules, please do not start multiple threads asking the same question.

Moderation requests should be resolved by editing the offending post in order to comply with the forum rules, not by starting another thread.

I will ask for this thread to be locked.