| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Price Lookup
Make it like this:
http://img388.imageshack.us/img388/1471/lookup2cx1.jpg Biff "Joe Black" wrote in message ... 101 - 150 151 - 250 251 - 300 301 - 350 125 - 230 $18.32 $19.97 $20.05 $20.56 231 - 350 $20.90 $23.29 $23.61 $24.63 351 - 450 $22.85 $25.86 $27.56 $29.35 451 - 550 $24.55 $28.27 $32.47 $34.56 551 - 650 $24.80 $30.61 $34.91 $36.95 651 - 800 $24.88 $33.83 $37.04 $38.87 801 - 950 $27.29 $37.05 $41.58 $43.43 this is how the matrix looks "T. Valko" wrote: You need to restructure your table. Make it so that both the vertical and the horizontal headers are the lower boundary of each size interval. See this screencap: http://img252.imageshack.us/img252/6260/lookupny4.jpg Biff "Joe Black" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| Price List overall price increase | Excel Discussion (Misc queries) | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| Lookup Postage Price [min & max weight] | Excel Worksheet Functions | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Threaded Mode
