Results 1 to 2 of 2

Thread: Drop down menu choice decides other cell values

  1. #1

    Question Drop down menu choice decides other cell values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    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)
    Attached Files Attached Files
    Hope that helps

    Roy

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •