Drop down menu choice decides other cell values

McCabe

New member
Joined
Jul 22, 2013
Messages
1
Reaction score
0
Points
0
Hi,
i'm trying to get a neighbouring cell (b2) populated by the next value in a drop down lists selected in cell A1. For example the user selects orange from a drop down menu in cell A1, B2 is automatically populated by the next value in the list - blue.

Not sure if this possible but your help would be appreciated

Thanks
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
I think the simplest way would be to use a ComboBox from the Forms controls.

Add a ComboBox from the Developer Tab in the newer versions of Excel, or versions prior to Excel 2007 you will need the Forms ToolBar. You must use the Forms version.

Right Click on the ComboBox & choose Format.

Input Range refers to the List
LinkedCell can be any unused cell

To get the selected item in a cell

=INDEX(Colours,$A$1)

To get the next in the list

=INDEX(Colours,$A$1+1)
 

Attachments

  • combobox_index.xlsx
    57.6 KB · Views: 22
Top