#### mberesh

##### New Member
What I'm looking to do seems logical (and simple), but I'm missing something when it comes to how to use radio buttons.

How the heck can I do this? What am I missing?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
You have to put each radio button within its own group.

So select group then insert a radio button, then select a new group and insert new button, etc... Then you can link separate cells.

Thanks for the really prompt reply, NBVC. Still need a little assistance.

If in different groups, then multiple radio buttons can be selected at the same time. I want to ensure that only one radio box can be selected at any given time AND the radio buttons each link to a different cell. Any thoughts?

I'm not sure that can be done so straightforwardly.

But what you can do is use if statements, to get your results.

So if you group is linked to Cell A1, which not directly next to the group itself.

Then in the cells next to the group add a statement in each, like:

=IF(A1=1,1,""), for first cell
=IF(A1=2,2,""), for second
=IF(A1=3,3,""), for third

And so on... get my drift?

Yeah. I don't think it's going to work though. If ever somebody adds an 11th item and inserts it in the middle (it is sorted alphabetically), that would throw all the numbers off. Not a big deal, I will use a check box and will create an error message if more than one is checked. Thanks anyways.

Replies
2
Views
413
Replies
2
Views
670
Replies
4
Views
211
Replies
3
Views
210
Replies
2
Views
474

1,203,674
Messages
6,056,680
Members
444,881
Latest member
Stu2407

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back