Thread: Price Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Black Joe Black is offline
external usenet poster
 
Posts: 11
Default Price Lookup

Hello, i want to lookup a certain price of a door in a price matrix that
matches criteria both in the left most column and topmost row that is between
2 values (for height) and 2 values (for width). So eg. i want to find the
price of a door which is 720 high X 450 Wide. I have to retrieve the price
from the matrix that the door sits in. So for left most column it maybe
between sizes 650-830High and 380-490wide, where 650-830 sits in one cell.
Any help appreciated. if i haven't explained myself properly or you need
further information please ask.

cheers