+ Reply to Thread
Results 1 to 8 of 8

Auto-fill Cells based on Drop Down Menu Choice

  1. #1
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    starter 2010
    Posts
    201

    Auto-fill Cells based on Drop Down Menu Choice

    Hi Guys, very novice with excel.

    Create a spreadsheet with drop down menus.

    I am trying to make this a very easy sheet here is what I am trying to do...

    Cell A1 will have a drop-down menu.
    I would like it to auto fill Cell B1 based on the selection of cell A1.

    Tricky part is, I do not want it to auto-fill with the same word from A1. I would need it to auto-fill a pre-determined code based on the selection of cell A1.

    Lets see the pre-determined words are...

    Apple = Orange
    Cat = Dog
    Green = Yellow

    If I select Apple in cell A1 it would auto fill B1 with Orange
    If I select Cat in cell A1 it would auto fill B1 with Dog
    If I select Green in cell A1 it would auto fill B1 with Yellow

    Hope that is clear enough.

  2. #2
    Forum Contributor
    Join Date
    08-30-2007
    Location
    Vancouver, B.C.
    Posts
    149

    Re: Auto-fill Cells based on Drop Down Menu Choice

    If there is no duplicate value of each of the value in A1, you can setup a table in a separate range/sheet as a reference. In cell B1, use the vlookup formula.
    If there are duplicate values, the solution is be a little more complicated.

  3. #3
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    starter 2010
    Posts
    201

    Re: Auto-fill Cells based on Drop Down Menu Choice

    There would be duplicate values... There could be 10 rows to select for the drop down, all 10 rows could be Apple = Orange.

    Any chance anyone can put this into an excel sheet to see better?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,899

    Re: Auto-fill Cells based on Drop Down Menu Choice

    You dont give us much to go on, some additional info would help. However, I *think* this is what you want...
    A
    B
    C
    D
    1
    Apple Orange Apple Orange
    2
    Cat Dog
    3
    Green Yellow

    C1=your search criteria
    D1=VLOOKUP(C1,$A$1:$B$3,2,0)

    If this waqs not what you wanted, please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    08-30-2007
    Location
    Vancouver, B.C.
    Posts
    149

    Re: Auto-fill Cells based on Drop Down Menu Choice

    Attachment 440736Sorry, what I meant is will there be duplicate values to "Apple", " Cat", "Green", etc. Will "Apple" always equal to "Orange"
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    starter 2010
    Posts
    201

    Re: Auto-fill Cells based on Drop Down Menu Choice

    The example spreadsheet is perfect Layzme, thank you so much.

  7. #7
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    starter 2010
    Posts
    201

    Re: Auto-fill Cells based on Drop Down Menu Choice

    Copy of Example.xlsxI actually need help taking it 1 step.

    So I made a new cell H5 with the drop down menu based values of column O. I would like to make the new cell in I5 with the value lookup based on H5. Could you fill that in for me?

  8. #8
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    starter 2010
    Posts
    201

    Re: Auto-fill Cells based on Drop Down Menu Choice

    Disregard that last message, figured it out. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Auto fill dependent drop-down list if only one choice
    By betheeem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2015, 03:02 PM
  2. VBA referencing drop down menu, and calulating based on choice in menu
    By rheinevetter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 08:16 PM
  3. Replies: 9
    Last Post: 09-18-2011, 06:10 AM
  4. Auto filling cells based on drop down menu selection
    By Candace84 in forum Excel General
    Replies: 1
    Last Post: 11-19-2010, 02:59 AM
  5. Replies: 1
    Last Post: 03-20-2009, 08:05 PM
  6. Updating graphs based on choice in drop-down menu:
    By tim.maciejewski in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-02-2009, 06:09 PM
  7. drop down menu that will fill in some other firlds based on choice
    By soundengineer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2007, 12:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1