Suppose your data is from A2 to C5 and your lookup value is in A10 then put
this formula =VLOOKUP(A10,$A$2:$C$5,3)

Vijay

"The Hit man" wrote:

I have seen similiar examples but not that were not using exact matches to
retrieve data. This seems simple and maybe I am over thinking but I have been
unable to crack this nut. I have a table where the first tier sales runs
between 0 and 20k and awards 1K commission. I want to be able to enter the
salse result for various team members and obtain the correct commission
amount based on their sales for the period. How should I complete the
commission formula for this process?

Sales Value Start Sales Value Stop Commission
$0 $20,000 $1,000.00
$20,001 $25,000 $1,100.00
$25,001 $30,000 $1,200.00
$30,001 $35,000 $1,300.00


Sales Commission
$5,000 $0
$25,001 $0
$32,000 $0