Making Excel to pickup correct value?

Attached file:

workbook.xlsx

Hello everyone,
Im compleately stuck on Friday at 17:00 oclock when everyone is already enjoying his weekend. I have Excel workbook where are four different dimensions:
HEIGHT WIDTH OPENING and PRICE
I will share a link to my workbook where I need to pick up always greater value for the final price indication.
For Example:
HEIGHT--WIDTH--OPENING--PRICE
1000----200----10---10000
1000----300----10---11000
1000----400----10---12000
1000----500----10---13000
1000----600----10---14000
1000----700----10---15000
2000----100----10---20000
2000-----200---10---21000
2000-----300---10---22000
2000-----400---10---23000
2000-----500---10---24000
2000-----600---10---25000
2000-----700---10---26000
1000-----100---15---15000
1000-----200---15---16000
1000-----300---15---17000
1000-----400---15---18000
1000-----500---15---19000
1000-----600---15---20000
1000-----700---15---21000
2000-----100---15---23000
2000-----200---15---24000
2000-----300---15---25000
2000-----400---15---26000
2000-----500---15---27000
2000-----600---15---28000
2000-----700---15---29000

Now if I type 2000 fo HEIGHT and 700 for WIDTH 15 for OPENING I will get 29000€. However If I type 1010 fo HEIGHT and 420 for WIDTH 14 for OPENING Im getting an error. What formula will move each dimension step higher and give me 27000€ as the answer?


Google Docs: File -> Open With -> Google spreadsheets
You can edit it there.

https://docs.google.com/spreadsheet/...0JqZUFIYVdkOVE

There is no any logic in pricing, they are very complicating numbers coming from alloy surcharge etc. But ofcourse they are placed according to size of the item. Higher and widther item is - bigger the price but there is no any formula for them, they are just numbers that are given.

I came up with 1010x420x14 = 27000€ from:
1010 next bigger number in the table is 2000
420 next bigger number in the table is 500
14 next bigger number in the table is 15

So we are getting 2000x500x15 which is 27000€ from our table.

Thank you!

Assuming the list is sorted and nice as it appears to be this should work.

Formula:

=MIN(IF(A2:A28>$H$6;IF(B2:B28>$I$6;IF(C2:C28>$J$6;D2:D28))))

This is an array formula and has to be entered with Ctrl+Shift+Enter.
http://www.mrexcel.com/articles/CSE-...ulas-excel.php
http://office.microsoft.com/en-us/ex...001087290.aspx