lookup function
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...
|