Nested VLOOKUP?
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
|