I would drop the leading 0 from your height category.

Then:

Lookup criteria:

...........A..........B
20...Weight.....0
21...Width......12
22...Length.....12
23...Height......6

=SUMPRODUCT(--(B2:B10=B20),--(C2:C10=B21),--(D2:D10=B22),--(E2:E10=B23),F2:F23)



--
Biff
Microsoft Excel MVP


"Antoine" wrote in message
...
hi,

Here is the idea behind the function I am trying to write:

"Knowing the width, height, length and weight, what is the price?"

----Box name---------Weight-----Box width---Box length---Box
height----Price
0lbs-12in-12in-06in-------0----------12----------12----------06----------10
0lbs-12in-12in-12in-------0----------12----------12----------12----------20
0lbs-12in-18in-06in-------0----------12----------18----------06----------15
0lbs-12in-18in-12in-------0----------12----------18----------02----------25
5lbs-12in-12in-06in-------5----------12----------12----------06----------15
5lbs-12in-12in-12in-------5----------12----------12----------12----------25
5lbs-12in-18in-06in-------5----------12----------18----------06----------20
5lbs-12in-18in-12in-------5----------12----------18----------02----------30
---etc---


thanks :)



ps: This is on Excel 2003 - (11.820.8202) SP3