I have a large list of stock items that I need to price update (in bulk if possible).

The main stock list (left hand side on the sample sheet) has all the items under one SKU, small, medium and large for example. But the item on the right is just the parent item.

I need to a formula that will look at the price on the right and update the child items on the left.

Hope this makes sense.

Attached sample.

sample.xlsx