Forum Discussion
A formula or function in excel for a different cell solution
I am trying to have excel, read line and and a make choice based on a another cells input see example I the person filling in the form selects a button, the amount to the right of the b...
Thank you that is what I need, can you send me the formula for that or where I can find the write up for it?
Rosemary68 It's not one formula. As said, you need a group box to "collect" the buttons, a linked cell and an INDEX formula. It's all in the file I uploaded. If you google for "group box Excel" you'll get many hits. Same for "radio buttons". Don't really know what I can add.