Hi folks

Here is a cut down version of a lookup im using to find the best choice for
a customer, as you can see from the row that starts 30 the customer requires
650 units and require the extra A and extra B package. The extra cost for 50
units on the 30 package is 25p (pence) therefore with the extra's this works
out at a total of £39.25.

What I need is a formula to lookup this value but then also show the next
best value plan, in this case it would be the 40 package as they would get
1100 units instead of 600 and as extra A & B are free on this package the
additional cost is only 75p


core plan core units core cost extra A extra B units req. extra cost total
cost
40 1100 £40.00 free free £40.00
35 850 £34.50 £5.00 free £39.50
30 600 £29.00 £5.00 £5.00 650 £0.25 £39.25
25 400 £24.75 £5.00 £5.00 £25.75
20 200 £20.00 £5.00 £5.00 £20.00

Hope this make sense

Nelly