Hi,
I'm trying to find the correct commission value given achieved sales amount and number of clients reached.
The correct commission is determined by checking different sales ranges against a range of client number.
VLOOKUP seems to work with specific unique data and I can't get it to work because my data of sales and clients have to be checked against multiple bracketed ranges. I've attached a table to illustrate my problem. I would really really appreciate help and thank anyone in advance who can assist me on this.
Regards,
Eve
Bookmarks