View Full Version : [SOLVED:] Depending on the marked radio button, the text in the cell changes
hrzagi
08-02-2022, 02:33 AM
Could someone please help me with the following. In a group I have three radio buttons with options A, B and C. In cells D2, E2 and F2 I have text that I would like to copy to cell I2 depending on which radio button is checked. For example, if radio button B is marked, then the text from cell E2 should appear in cell I2. Thank you.
p45cal
08-02-2022, 03:12 AM
Link the cell of one of the three option button to a cell (I used A8). All the buttons in that group will be linked to the same cell.
Formula in I2:
=INDEX(D2:F2,A8)
hrzagi
08-02-2022, 03:58 AM
Great. Thank you.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.