Hi Anh,
See Debra Dalgleish's VLookup tutorial at:
http://www.contextures.com/xlFunctions02.html
---
Regards,
Norman
"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...