Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested VLOOKUP | Excel Worksheet Functions | |||
VLOOKUP NESTED | Excel Worksheet Functions | |||
Nested IF with a VLOOKUP? | Excel Worksheet Functions | |||
Nested vlookup | Excel Discussion (Misc queries) | |||
Nested vlookup? | Excel Worksheet Functions |