Results 1 to 6 of 6

Insert Pay Rate Based On Employee Selected

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-17-2007
    Location
    Michigan, US
    MS-Off Ver
    2007
    Posts
    111

    Insert Pay Rate Based On Employee Selected

    I have a pretty basic spreadsheet set up to calculate payroll for some of our temporary workers. I have a table of workers names and their pay rates in the lower right hand side of my worksheet.

    Up until now I have been glancing over to determining their pay rate and manually entering that rate into a specific cell (I2) to start the pay calculations. What I would like to do is somehow add another column to the left of their names and place an "x" or something in that column for the specific employee I am calculating. Once the "x" is placed there I would conditionally format the employees name to be highlighted and have their wage entered into cell I2.

    So what I need is a formula to enter into cell I2 which searches cells K5:K24 and when it finds an "x" it enters the payrol rate from the corresponding cell in the range of N5:N24

    I know I could revamp my spreadsheet and make a drop down list of names and when a name is selected do a vlookup for the pay rate, but I am looking for a different and hopefully simpler solution.

    Thanks, Spence
    Last edited by Spencer; 02-06-2009 at 03:53 PM. Reason: Follow Up Question

Thread Information

Users Browsing this Thread

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

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