[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Mike P[/TD]
[TD]Hours[/TD]
[TD]Hours[/TD]
[TD]Hours[/TD]
[TD]Hours[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Job[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[/TR]
[TR]
[TD]8/6/16[/TD]
[TD]Garbage[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/7/16[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/8/16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here is a simplified version of my weekly summary spreadsheets, I have one of these for every employee, I'm trying v-lookup now and it doesn't seem like it will work because the person's name is not in every row next to the date, I suppose I could hide a row and do it that way but other than editing all 15 sheets is there another way?
I'm looking at doing an if statement that returns the value of the cell where the name is only if there is a positive value in the hours column for the given day, which seems to work but I'm not sure how to "simplify" it so that if the first person didn't work that day, it automatically looks at the next person, and so on? I was trying to use a combination with the "indirect" function and a named group which has all the sheet names in it but I can't quite get the formula down:
=IF(COUNTIF('[Weekly Summary.xlsx]SheetNames'!$A$6:$A$12,A1)>0,'[Weekly Summary.xlsx]SheetNames'!$K$3:$R$3)
When I try this it only reads the first value of the list "sheetnames" and therefore only looks at the first sheet.
