I am trying to work out a price list. We work with product discount codes and we have different markups on each discount code. I need to work out the new price on a spreadsheet with thousands of parts. It must look up the discount code and then its markup and then calculate the new sell price for each discount code according to there markups.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook demonstrating all this data you have laid out, or a small subset of it, enough to show us what you're doing and the exact basic layout of your workbook.

Make sure the workbook demonstrates your desired results manually demonstrate a couple of these and the expected result so we can see the end goal.