Hello,
Hopefully this reads correctly. Basically I need to find a formula to check specific values within one column and then use these values to find the correct percentage multiplier so that a certain premium can have its commission worked out correctly.
I have attached a basic table to show my meaning. And need to be able to work out the correct commission from a given premium using the right commission rate.
Basically the three locations shown in columns I and J (Cambridge, Ely and Newmarket) all have a specific percentages of commission assigned to them. I need to then search column C to find any locations that match these three and then take their Amount Paid (Column D) and multply it by the assigned percentage in Column J. Column F will then need to show the amount of commission.
I have tried a mix of the IF statement and VLOOKUP formula but cannot get one that fits.
I hope what I am trying has been explained correctly.
Any help would be greatly appreciated.
Regards
Bookmarks