Applying specific discount dependent on SKU type

[murrayjl03]

Hi!

I have a pricing file where i have various SKU's which are in the type ABC-XXX, AD-XXX & GE-XXX (could also be more but using these as examples). Each SKU has a price.

I have another tab where i have listed what the % discount should be depending on the SKU type but don't know how to get it to check this tab and apply the discount accordingly.

Can anyone help?

Pricing tab:

Discount tab:

 

[Norie]

You could try something like this.

=VLOOKUP(LEFT(A2,SEARCH("-", A2)), Discount!$A$2:$B$4, 2,0)