Applying a value to different employee

Rhodestransit

New Member
Joined
Feb 8, 2011
Messages
41
Im not sure if this will make sense
I have drivers that driver their normal bus runs, each run has an agreed amount of time the run takes to complete, each driver is on a different pay rate depending on years of service, sometimes a driver may work another run.
I want to know if I can have the sheet check for each drivers name and where it appears on the sheet, then apply the relevant numbers of hours to that driver.
Example c3 has a value of 3 hours so what ever name is in that cell they would be paid 3 hours.
we have around 600 cells each with a different value, and 200 employees that could be in any of those cells.
I am really stuck on this one.
 
A further embellishment I would like to add,
If the same person were in cells C3 and G3 can I add a value of 2
so to have it auto check for the names in columns and if they match add 2
I would need it to check this against all the drivers on my list.
 
Upvote 0

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,224,621
Messages
6,179,946
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top