Looking to create a dynamic commissions sheet based on agent and product

Good day,

Hoping someone can assist.

Backstory:
Some agents make a bit more than others since they're on a new contract. Different ranges of products give different amounts of commissions.

Example:
Lucy sells Product A. She gets $5 commission from it.
Sally sells Product A. She gets $10 commission from it since she's on the new contract.
Lucy sells Product K. She gets $10 commission from it since it's in the next tier of products.
Sally sells Product K. She gets $15 commission from it, again, new contract but on the next tier of products.

I don't mind keeping the list of products and agents for it to check against on another sheet.

Sorry for the long wait time on this. Please see the attached.

Here is one solution. I created Tiers based on the device, and then assigned values to the commission based on the tier. On the Agent Sales sheet I added two columns (F&G) and changed the summing in the Total Commission column.

This works great!

Though now I need to add in some extra things. So, based on what you have setup, is it possible to then check against some other products - the thing is these don't have tiers unlike the previous ones. Was wondering if it was placed as a different tier, say Tier 0, it would check to see what the amounts are for that product, times it by 1 (which is in the top right side with the other tiered pricing)?

Probably easier to see what I mean by looking at the document.

I'm honestly not sure why I didn't think to put it like that, but holy crap this makes more sense than the way I was going about it.

Thank you!