lookup function
I have a sheet listing comission rate eg. sales less than $200, the rate is
..5%, less than 300, the rate is 1%..etc. Then i have another table showing
different sales value of different workers. How do i find the commission rate
per worker using lookup functions??
Please help me..thx a lot
|