Radio Buttons
Good day!
Attached is the spreadsheet Im working on. Two Tabs - DATA SHEET AND SUMMARY PAGE.
Basically, I would like to be able to click the radion button in the summary page and have the data from DATA SHEET to populate the colums in SUMMARY PAGE.
Appreciate any advice/help.
Regards
Good day!
Attached is the spreadsheet Im working on. Two Tabs - DATA SHEET AND SUMMARY PAGE.
Basically, I would like to be able to click the radion button in the summary page and have the data from DATA SHEET to populate the colums in SUMMARY PAGE.
Appreciate any advice/help.
Regards
Here is the solution.
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
Thanks! Thats exactly what I need. Just wondering, how will I be able to customize it? Sorry, fairly new to this,
Many thanks
Originally Posted by mubashir aziz
okay
let me tell you first about Radio Button.
Right clock on the Radio Button->Format button->control ->cell Link , cell link =$J$4 ( i have made this cell absoulte). When u'll click button 1 its value ll be one and when u'll click 2nd button its value changed to 2.
Now comes to formuls of vlookup here I'm using this $J$4 to move around two ranges.
IF($J$4=1
Please Login or Register to view this content.
I've applied if condition to check if linked cell ($J$4)is 1 then select the range one and if its not 1 then select other range.
here its value is 1 mean first part will go .....
'DATA SHEET'!$B$4:$E$15,2,FALSE
IF($J$4=2 here i had only 2 options so I didn't write 2 so if its not 1 then go to other range.
VLOOKUP($B$4,'DATA SHEET'!$B$20:$E$31,2,FALSE))[/
Thanks for giving the formula. So just wondering, If i have multiple options, let say up to hotel 10. Which variable in the formula should I change? Thanks
okay
let me tell you first about Radio Button.
Right clock on the Radio Button->Format button->control ->cell Link , cell link =$J$4 ( i have made this cell absoulte). When u'll click button 1 its value ll be one and when u'll click 2nd button its value changed to 2.
Now comes to formuls of vlookup here I'm using this $J$4 to move around two ranges.
IF($J$4=1Please Login or Register to view this content.
I've applied if condition to check if linked cell ($J$4)is 1 then select the range one and if its not 1 then select other range.
here its value is 1 mean first part will go .....
'DATA SHEET'!$B$4:$E$15,2,FALSE
IF($J$4=2 here i had only 2 options so I didn't write 2 so if its not 1 then go to other range.
VLOOKUP($B$4,'DATA SHEET'!$B$20:$E$31,2,FALSE))[/
There is no need to quote my Full reply
You will change only If statement incase of more radio button like
if IF($J$4=1, Select Frist Range, if IF($J$4=2,Select 2nd range, if IF($J$4=3,Select 3rd range and so on ....................
we can make is easy by giving names to ranges but it will be complicated for you on this stage.
Thanks again for your help and being patient. I tried to do what you said however the formula is not working, would u kindly give me the formula, let say if i have 5 radio buttons.
Many thanks
I've given the names to ranges so pls. don't get confused with range names. you can change ranges of these names as well.
Great Help! Many thanks again!
- Cheers!
Hey I was just thinking that if you have 50 items then ?
so i made this change by using indirect function and now you can enter as much items as u can but formulas will remain the same.
Just write this formula in relevent column
C5: =VLOOKUP($B5,INDIRECT("HOTEL_"&$J$5),2,FALSE)
D5: =VLOOKUP($B5,INDIRECT("HOTEL_"&$J$5),3,FALSE)
E6: =VLOOKUP($B5,INDIRECT("HOTEL_"&$J$5),3,FALSE)
Thanks again! I will try and figure it out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks