Thread: Nested VLOOKUP?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Antoine Antoine is offline
external usenet poster
 
Posts: 10
Default 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