PDA

View Full Version : [SOLVED] Combobox help



DarrylW
06-15-2005, 06:33 AM
Hi,

I'm a real novice when it comes to excel so apologies if this seems really simple to do for most of you!

I'm designing a very basic questionnaire with combo boxes for the users to select there answers. Which is simple enough to make, but what I want to next is link the answers to sheet2 which I've done in my attached example. But instead of the output being 1, 2, 3 how can I make the answer be exact to what's in the combo box for sheet2? i.e. "whfc"

Thanks for any help......

Darryl

Bob Phillips
06-15-2005, 06:53 AM
You could lookup the value in an adjacent cell


=INDEX(Sheet1!E3:E5,A2)

DarrylW
06-15-2005, 06:58 AM
Simple as that! Told you I was a novice!

Thanks for your help