Pressing one radio button to select another radio button

Hi guys

Just wondered if any one can help me?

I’ve got a spreadsheet with radio buttons for 4 companies and another 4 radio buttons for parts

What I am trying to do is when a user selects one of the companies it will automatically select the relevant part number

So when Company1 is selected then Hardware ABC is selected in the next set of radio buttons

Company2 = 123
Company3 = XYZ
Company4 = 321

I’ve looked around for a solution and tried a few things I thought looked similar to what I am looking for to no avail

Many thanks in advance