using drop downs to calculate pay rate

Posted on 2012-08-20
Last Modified: 2012-08-28
Hi guys,

I have an excel spreadsheet that I'm using to keep track of employee projects.

I'm using drop down lists to select the employee. I want to be able to determine the pay rate of the employee and if no employee is select, show a blank value.


IF  D3 = BLANK then show BLANK, if D3 = "John Doe" then 25, if D3 = "Bob Smith" then 28

i Googled, but couldn't find anything close to what I'm doing.
Question by:GTechForce
    1 Comment
    LVL 39

    Accepted Solution

    put a list on sheet1 with in column A your employee names, in column B your rate.

    now, on the page where you have your drop down, put this formula where you want the rate to be

    for excel 2007-2010


    In addition, you can also use that list as the source for your dropdown.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot 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.

    759 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

    12 Experts available now in Live!

    Get 1:1 Help Now