+ Reply to Thread
Results 1 to 3 of 3

Automatically selecting staff hourly rate and grade

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    ipswich, england
    MS-Off Ver
    2010
    Posts
    30

    Automatically selecting staff hourly rate and grade

    Hello All

    Apologies if this question has been posed or answered before but I have been trying to resolve this using vlookup and IF statements but I am getting nowhere.

    I have attached a copy of the excel sheet.

    This forms part of a larger costing sheet. in the select staff column there is a drop down list so we can select which members of staff will be working on a project. What I want to happen is that once the person(s) have been selected the staff grade and hourly rate columns are automatically populated.

    Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-17-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    21

    Re: Automatically selecting staff hourly rate and grade

    revisedStaff costs - 15-09-2015.xlsx
    One way is, put the values in column M into column O as well. Then you can do this.

  3. #3
    Registered User
    Join Date
    02-01-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    26

    Re: Automatically selecting staff hourly rate and grade

    Assuming that your staff list is set up as rows with columns to reflect staff grade and hourly rate then "Index / Match / Match" will do what you are looking for.

    See if this will help.
    simon3-Staff costs - 15-09-2015.xlsx

+ 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. how to multiply h:mm value by an hourly $ rate
    By Johstra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-25-2015, 10:18 AM
  2. Replies: 1
    Last Post: 02-28-2014, 02:31 AM
  3. [SOLVED] What function can I use to add a flat rate plus an hourly rate?
    By dosmin777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2014, 02:26 AM
  4. Multiple Days Hourly staff count
    By aehartle in forum Excel General
    Replies: 14
    Last Post: 05-19-2010, 11:42 AM
  5. Timesheets for hourly paid staff
    By jennii in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 05-05-2007, 03:54 PM
  6. Hourly Rate
    By Eskimos in forum Excel General
    Replies: 5
    Last Post: 12-01-2006, 03:56 PM
  7. Hourly Pick Rate.
    By pobrien31 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-31-2006, 01:34 PM
  8. VBA To Decide Which Hourly Rate
    By Jasper in forum Excel General
    Replies: 1
    Last Post: 04-21-2005, 10:06 AM

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