DropDown Lists in Excel

Posted on 2011-10-26
Last Modified: 2012-06-27
I have an excel spreadsheet that uses drop down lists to select specific items, I would like to it to autofill certain cells with set figured when a particular item is selected from the drop down list.

EG.  A spreadsheet that has a list of cars and when you selct a certain make it autofills cells for manufacturer, year, body type etc.

Has anyone got any ideas on how to do this.

Thanks in advance
Question by:Bellscape
    LVL 8

    Expert Comment

    by:Amit Khilnaney
    I guess you have to use traditional way

    If else statement ..

    Open in new window

    LVL 33

    Accepted Solution

    You need to use a Vlookup function to get the corresponding data to show up on the fields.

    I've attached a sample file. When you select a name on column B, it autofills the column A with the corresponding employee number using a formula like this:


    Hope you understand the general idea.

    LVL 1

    Author Closing Comment

    What I was after

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now