Sir Babydum GBE
11-06-2007, 04:45 AM
Attached is a workbook with a mockup of something I'm trying to do.
There's a sales sheet that contains the sales from two types of agents - telesales & field sales.
The banding guide tells you what band each agent sits in depending on their sales. So if a field sales agent earns 6 sales, he is in band 1. This is because band 1 for field sales is anything from 5 to 9 sales. Band 2 is 10 to 14 etc.
How do I do a lookup that I can copy down the cells on the sales sheet please?
Sir BD
(We're selling intergalactic peace machines, by the way. So if you can help you're doing an imense amount of good for the whole galaxy)
There's a sales sheet that contains the sales from two types of agents - telesales & field sales.
The banding guide tells you what band each agent sits in depending on their sales. So if a field sales agent earns 6 sales, he is in band 1. This is because band 1 for field sales is anything from 5 to 9 sales. Band 2 is 10 to 14 etc.
How do I do a lookup that I can copy down the cells on the sales sheet please?
Sir BD
(We're selling intergalactic peace machines, by the way. So if you can help you're doing an imense amount of good for the whole galaxy)