Forum Discussion
Solved
Lookup values
Needing help with lookup values. Every time I try to enter the lookup value for my HC and hours worked my data for my Sum_ev (under the date) changes. I have merged my 2 queries and am having issues.
See the attached version. You may have to recalculate (F9) since the workbook refers to another workbook that I obviously didn't have.
See the attached version. You may have to recalculate (F9) since the workbook refers to another workbook that I obviously didn't have.
That worked perfectly. I was trying to do that formula but for some reason I kept missing something. So, lets say I wanted to add all 3 shifts together for that day to get for the day as a whole. So, I would have to add another column to sheet 2 for a daily total (all 3 shifts combined). I've tried several times but something is not working.
New version attached.
