Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee = rate of pay
How do I set up a cell that autofills the rate of pay based on the employee
name entered in another cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee = rate of pay
Take a look a VLOOKUP function or INDEX and MATCH in Help menu
"laurel" wrote: How do I set up a cell that autofills the rate of pay based on the employee name entered in another cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee = rate of pay
Hi Laurel,
See if this helps you out; Employees names in A2:A4 Their pay rate in B2:B4 Their hours worked in C2:C4 A drop down valadation list of the employees in D2 This formula in E2 =VLOOKUP(D2,A2:B4,2,0)*VLOOKUP(D2,A2:C4,3,0) Select an employee from the drop down and their gross pay is returned in E2 HTH Regards, Howard "laurel" wrote in message ... How do I set up a cell that autofills the rate of pay based on the employee name entered in another cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm a salaried employee, ?how to calculate actual rate of pay | New Users to Excel | |||
XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions | |||
Employee Rate % | Excel Worksheet Functions | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
Referencing a newly created worksheet | Excel Worksheet Functions |