Insert Pay Rate Based On Employee Selected

Originally Posted by JBeaucaire

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

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