• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula to retrieve value from option button

G

ganeshm

Member
Hi...

I have a sheet where i click say "manager", the value in the corresponding column appears. Likewise if i select the next option "professionals", i would want the value in the corresponding formula to appear. Just guide me what formula should i use in order to complete the table. Excel file is attached for reference.

Regards,
 

Attachments

  • Book3.xlsx
    15.7 KB · Views: 11
Last edited:
If you want the values in Rows 23-29 to be completed what does each column mean?
If you want to find out which button is pressed use: =INDEX(B4:J4,,N2)
Otherwise I am confused about what you want ?
 
Hi ganeshm,

Your Index formula has locked array refrence and use of choose is also wrong. I will suggest you to use below formula:
=HLOOKUP($N$2,$B$5:$J$19,1)
and change last row argument as per your need.

Regards!
 
You must log in or register to reply here.
Back
Top