Populating a cell with a number dependent on the range it falls between defined by a table

[Be_Hemoth]

Hi guys,


Would love to know if what I am trying to do it possible? Breakdown of what I'm looking to do is below.


Column D configures the markup percentage based on the value range that Column C falls within.
This range is on sheet 2 and contains the min. (A) and max. (B) range, as well as the corresponding percentage (D) that I'd like automatically added to Column D, sheet1.
For values under $2, I would like to add the value $2 (D) instead of a %


https://www.dropbox.com/s/znak0ujf28pa2yd/Garment Sales Price.xlsx?dl=0




Really looking forward to seeing if someone can help me configure this.
If there is a better way to go about this, I am totally open to ideas.




Thanks a tonne for your time!
Brian

 

[Be_Hemoth]

Thi has now been solved. I'm unsure how to delete thread however.