Thread: lookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anh
 
Posts: n/a
Default 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