I'm working on a monthly timesheet template to autofill 8 hours on the days the employee works and 0 for their days off. On the bottom of the sheet it will have the total forcasted hours. I keep getting error messages when trying to write the formula/function. The layout is as follows:
TIMESHEET TAB
AJ3=work schedule code (AA1)
M3=employee name from drop list
V3=employee ID from VLookup formula
AI3=Period ending
B7-AF7=date (1,2,3,etc)
B8-AF8=day of the week (Sat,Sun,Mon,etc)...auto changes when month changes
LOOKUP TAB
Employee info table-
A1:C:50=Employee Name, ID, Assigned Schedule Number
Work Schedule table-
Columns as days of week (Sun-Sat) col P:V
Rows as schedule number (AA1-AA7) row 2:8
rows and columns filled with 8 and 0 for Reg Days work and Days off
I want to fill hours in row B9:AF9 on the timesheet with either 8 or 0 depending on the work schedule (table ref) and day of the week (row $B$8:$AF$8)).
I've tried Lookup function but I get a #Name error probably because the schedule number is VLookup value?? Hope this makes sense. Tried INDEX, MATCH, LOOKUP... I'm not sure where to start. Thanks in advance for help!
TIMESHEET TAB
AJ3=work schedule code (AA1)
M3=employee name from drop list
V3=employee ID from VLookup formula
AI3=Period ending
B7-AF7=date (1,2,3,etc)
B8-AF8=day of the week (Sat,Sun,Mon,etc)...auto changes when month changes
LOOKUP TAB
Employee info table-
A1:C:50=Employee Name, ID, Assigned Schedule Number
Work Schedule table-
Columns as days of week (Sun-Sat) col P:V
Rows as schedule number (AA1-AA7) row 2:8
rows and columns filled with 8 and 0 for Reg Days work and Days off
I want to fill hours in row B9:AF9 on the timesheet with either 8 or 0 depending on the work schedule (table ref) and day of the week (row $B$8:$AF$8)).
I've tried Lookup function but I get a #Name error probably because the schedule number is VLookup value?? Hope this makes sense. Tried INDEX, MATCH, LOOKUP... I'm not sure where to start. Thanks in advance for help!