Return Value based on two variables and number range

[nickymac]

Hi, I am trying to get a result from two variables.
Variable 1 is a name, say Ian. Variable two is a number (number of sales).
If Ian hits a number of sales, then a certain commission value will be returned.

If Ian hits 999 sales, he gets a different commission to 1000 - there are various stepped targets like that.

The commission value will change for each person depending on their respective sales target. I want to see that in the list of names.

I have a sheet but can't attach on as don't have permissions to upload a spreadsheet. Can anyone help based on the information I have set.

I've tried to use index match but not getting it right so far.

 

[nickymac]

To clarify on the sales, the steps will be broad, say 100, 250, 500, 750, 1000. However the sales may be exact like 359 - should return the commission for 250. 748 should return commission for 500 - only if it meets or exceeds 750 would it hit the 750 commission