Lookup up values

[Bubba]

I have done this before but can’t remember how. I think I used vlookup but any help will be appreciated. What I want to do is figure a commission base on the number of units sold on new and used units. The minimum commission should be $125.00. C30 equals the total number of units. Column H2 should figure the commission for new base on the gross in column E2 of $490.00 x 32.5% based on the 14 units.

[Bryan Hessey]

I have done this before but can’t remember how. I think I used vlookup but any help will be appreciated. What I want to do is figure a commission base on the number of units sold on new and used units. The minimum commission should be $125.00. C30 equals the total number of units. Column H2 should figure the commission for new base on the gross in column E2 of $490.00 x 32.5% based on the 14 units.

The lookup for this will require that your table remains sorted, and is

=VLOOKUP( units , table , column-across , true )

where 'units' is the cell that contains the number of units sold
table can be a Named Range table or a range address E10:F15 or Sheet2!E10:E15 etc
'column-across' is the column number from within the array, 1=Units, 2=Rate
and 'True' says take the closest (under this figure) match.
(specifically: If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned)

so, in the cell that will hold the commission rate, the formula

=VLookup(C$30, table ,2,true)

where 'table' is your table should go close.

hth
---