Perhaps a sample construct for your situation would also help?
http://cjoint.com/?mzk3YMTmpY
Anh_wks.xls

Assuming the commission table is in Sheet1, in A1:B6

Sales Comission rate
200 0.50%
300 0.75%
500 2.50%
750 3.00%
1000 3.50%

And in Sheet2, sales are listed in B2 down

Name Sales Comission rate
Anthony 487
Bill 568
George 250
Peter 855
Goliath 1356

Put in C2, copy down:
=IF(B2="","",VLOOKUP(B2,Sheet1!A:B,2,TRUE))

For the sample,
we'd get the resulting comm rates in col C:

Name Sales Comission rate
Anthony 487 0.75%
Bill 568 2.50%
George 250 0.50%
Peter 855 3.00%
Goliath 1356 3.50%

(The above presumes a simple "flat" comm. rate structure,
not a complex "tiered" one)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Anh" wrote in message
...
It's lika table like this:
Sales Comission rate
200 and under 0.50%
300 and under 0.75%
.................................................. ...
1000 and under 2.50%

Then i have a list of different people with different sales figures:
Name Sales Comission rate
Anthony 487 ?
Bill 568 ?
......................................
(up to 15 people)

I need to find the comission rate for each people by using lookup & the
table above. I do not know how to do it...