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.

You only need to look at column A. I assime you values are in order like this

1 5 123
6 10 456
7 20 789


Looking at Column A the formula below will return for any value 1<=x<6 the
number 123. You don't need to look at the value 5 in Column B.

=VLOOKUP(D7,Sheet1!A2:C10,3,TRUE)

Looks up 1 in column A, and returns the value from column C (the third
parameter 3) in the same row.

If an exact match is not found, the next largest value that is less than
lookup_value is returned. If FALSE, VLOOKUP will find an exact match

"Renegade40" wrote:

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.

Works like a charm. I did not realize there was a way to search all three
columns at once. Thanks very much..

"Joel" wrote:

You only need to look at column A. I assime you values are in order like this

1 5 123
6 10 456
7 20 789


Looking at Column A the formula below will return for any value 1<=x<6 the
number 123. You don't need to look at the value 5 in Column B.

=VLOOKUP(D7,Sheet1!A2:C10,3,TRUE)

Looks up 1 in column A, and returns the value from column C (the third
parameter 3) in the same row.

If an exact match is not found, the next largest value that is less than
lookup_value is returned. If FALSE, VLOOKUP will find an exact match

"Renegade40" wrote:

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.