This should be pretty easy, but I'm a bonehead and can't get it to work.
Say I have a combobox in A1,
Later, in B2, I want to show the selected value from the combobox. Not the index but the value.
example - user makes choices across multiple sheets which are then nicely presented as a summary elsewhere in the same book.
I've tried playing with indirect and offset but I can't get it.