+ Reply to Thread
Results 1 to 2 of 2

Changing cell value based on drop down box choice

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    Winnipeg, Manitoba
    MS-Off Ver
    Excel 2007
    Posts
    2

    Changing cell value based on drop down box choice

    Hi,

    What I am trying to do is change the value of a cell based on the value of a drop down box. For example, if an employee works a regular shift, night shift (+$1.00) or foreman shift (+$2.00) their rate would change. I have the positions in a drop down box and need their rate to change accordingly. I figured a vlookup table would help me find the additional rate to add to the employees regular rate but I can't seem to get the formula to work for multiple choices.
    Attached Files Attached Files
    Last edited by CDNGirl; 02-26-2015 at 12:07 PM.

  2. #2
    Registered User
    Join Date
    08-01-2013
    Location
    Winnipeg, Manitoba
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Changing cell value based on drop down box choice

    I figured it out om own. Thanks for reading!

+ 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. Restrict entry in various cells based on drop down choice in another cell
    By Stretch617 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2013, 04:09 PM
  2. [SOLVED] Cell reference based on another cell choice from a drop down list.
    By enoch5939 in forum Excel General
    Replies: 2
    Last Post: 12-07-2012, 12:04 PM
  3. [SOLVED] Autofill Based on Choice From Drop Down List?
    By jbakajust1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2012, 11:57 AM
  4. drop-down list changing according to choice made
    By choc_penguin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2006, 05:50 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