Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup price formula
I have a work sheet with prices on it. Across the top are widths down the
side is length. 24 30 36 ............................120 24 $1.00 $2.00 $3.33 30 2.20 3.20 4.20 .. .. 120 On another work sheet i have a width and length cells when i enter sizes i want it to return price. EG width might be 26 and length maybe 27 i want to return price of 3.20. does anyone know how to do this. i new to excel so keep it simply please if possible |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Price Lookup | Excel Worksheet Functions | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
Lookup Postage Price [min & max weight] | Excel Worksheet Functions | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
formula for - price times discount times tax = final price | New Users to Excel |