You want Vlookup. Something like:

=vlookup(a1,$d$1:$f$1,3,true)

Make sure your 'column 1' is sorted in ascending order.

Regards,
Fred.

"joecool12345" wrote in message
...
I am trying to calculate a commission % based on a gross profit % range.
So
I have 8 rows of % ranges with 3 columns, column 1 is greater than and
column
2 is less than, the third column has the commission %. Can someone tell
me
how to have a formula look at the table and tell me which % should be used
for the calculation?