Hi there,
I am trying to figure out how to return an item from a named range using a radio button on a different worksheet.
Ideally, I'd like to be able to return a single item and then in another separate instance return a whole array.
So below, the single item example would be click one radio button under strawberry and it returns the single selection "strawberry" to the cell.
I'd also like to be able to make a selector that return the entire array. So for example if I had a set of radio buttons for Green Fruit, clicking it would return the entire list of items on the GreenRange Named Range.
I am able to do some of this using index/match, but I am having trouble with the named arrays as I have so many (30 or so) that index/match is tedious on a one by one basis.
thank you for your help!
-Will
I am trying to figure out how to return an item from a named range using a radio button on a different worksheet.
Ideally, I'd like to be able to return a single item and then in another separate instance return a whole array.
So below, the single item example would be click one radio button under strawberry and it returns the single selection "strawberry" to the cell.
I'd also like to be able to make a selector that return the entire array. So for example if I had a set of radio buttons for Green Fruit, clicking it would return the entire list of items on the GreenRange Named Range.
I am able to do some of this using index/match, but I am having trouble with the named arrays as I have so many (30 or so) that index/match is tedious on a one by one basis.
thank you for your help!
-Will