Hi gang:
Well here is what I'm try to do.
I have 3 columns on a worksheet named shipping. column A (greater then)
contains values from 0 to 50,000.
Columns B (Less than) contains values from 5 to 51,000.
Column C is the shipping amount. On another worksheet I have an order form
and want to compare the total order with the shipping cost to provide a
total cost.
I would like the order form to lookup shipping amounts either greater then
but less then and come up with the amount from Column C.
I have tried the following If G15 is greater then column But Less then
column B then Column C.
All I get is an error #name.
Is this possible or do I need to change the way this is layed out. I'm
trying to transfer this from a paper form to computer form in excell.
Any help would be greatly appericated.
Thanks.
Cliff.