weight not over !!!!!
Posted by Left on January 08, 2002 8:05 AM
sheet 1 = a price list ..... 2 = $4
4 = $6
6 = $8 etc ....
when the user enters a amount on sheet2(order sheet) a lookup formula looks for the amount and returns the price BUT when a user enters a `middle` amount (e.g. 3) it returns the price of the 2 and i need the price of the 4 !!!
any help would b gr8ty appreciated ....
thx in advance ......
Posted by Mark W. on January 08, 2002 8:14 AM
=VLOOKUP(3+MOD(3,2),{2,4;4,6;6,8},2) (nt)
