MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)