+ Reply to Thread
Results 1 to 6 of 6

Insert Pay Rate Based On Employee Selected

Hybrid View

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

    Re: Insert Pay Rate Based On Employee Selected

    Quote Originally Posted by JBeaucaire View Post
    If the I2 is being used to only calculate one employee and when you're done, you copy that off somewhere and do another employee in the same spot, then how about this to match closer to your original request:

    To get the name to appear on its own in H2:

    =INDEX($M$5:$M$24,MATCH("x",$K$5:$K$24,0))


    To get the pay rate in I2, same idea:

    =INDEX($N$5:$N$24,MATCH("x",$K$5:$K$24,0))


    If more than one X is in column K, you might get weird results.
    Cutting and pasting both of those formulas worked perfectly.

    I will try to reverse engineer the logic later on, but for not I am back to work.

    Thanks,
    Spence

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

    Re: Insert Pay Rate Based On Employee Selected

    This has been working great, a major improvement over what I was doing before. I am wondering if it would be much trouble to add radio buttons instead of the "x" that I am using.

    If anyone could point me in the right direction on that I would appreciate it.

    Thanks, Spence

+ Reply to Thread

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