I have a group of radio buttons with labels in adjacent cells. How can I arrange for the radio button with the label matching a target cell value to activate?
Here's an equivalent example to what I'm trying to achieve:
Here, you can see two radio groups: "buyer" and "destination". The labels are in column A, the radio groups are in column B, and the target values are in column C. The values in column C are what we control, and we want to activate the correct radio button by looking up the value of the target cell in the list of labels in column A. That is, if C2 changed to "Internal", then we want the radio button in cell B4 to activate. The radio buttons in B7 and B8 will be unaffected as they are in a different group.