Help to calculate discounted price per item based on table on same page

[kareylee]

Hello i am working in a spreadsheet. On the sales tab I would like to have a reference table with discounts, for example discount 1 discount 2 etc which when entered on the main part of the spreadsheet will return the actual price with the amount of the discount that is represented by discount 1 2 etc. This is so that it will be user friendly for whoever is using it to enter the discount 1 2 or whatever it will automatically calculate the discount. Ive tried a few formulas and im not getting what i need.
This is for the sales tab only. Thanks for any help
See attached

[Estevaoba]

Try
=E3-VLOOKUP(F3,$N$6:$P$12,3,0)

[kareylee]

Thank you that worked great.Appreciated

[Estevaoba]

You're welcome.
Thanks for the feedback and the rep points added.