Price list to update values based on a drop down list of companies

Hi All,

I am trying to get a price list, where there are multiple categories in their own 'boxes' (see attached workbook), to update the prices by a percentage depending on the company selected from a drop down list.
In the sample I have attached there are only a couple of these categories but in reality there will be about 20 on the worksheet and I need all prices to update automatically based on the original prices.
I am running Excel 2019 on this project.

Hoping there is any easy way to accomplish thisPrice List test.xlsx

Hi Sam,
Many thanks for the reply...I am hoping to find a way that it appears in the box where the current pricing is...so everything just updates depending on the company selected

Thanks Sam,

Unfortunately it is not going to work for the worksheet/price list I have as it is a lot 'busier' and more varied than the sample I used here.
I am wondering if I create a duplicate of it in another worksheet and use that as the 'master file' that the main page refers back to on the vlookup.
The base price gets updated once a month and now there are a growing amount of companies with various % of that base price.

Sam,

Thankyou very much...I have the solution thanks to the sheet/formula you sent