Table Look Up

[joecool12345]

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?

 

[Fred Smith]

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.