Update price based on service name

Hi, I am stuck on how to update cells for new prices.

To give a bit more info:

I have 3 columns, 1 service category (service types i.e “software” etc.), 1 price type (“Internal” vs “external”) and price type (a number).

Note: Price only shows up for Internal.

What I want to do is expand the new price from Interal to external for all service within the same service category.

For example, if software internal $100, then I want Software external at $100. But Supplies internal $50, then I want Supplies external at $50.