Jul 23 2020 11:42 AM
I have a data set containing employee names (in Column G) and their work-shifts (in Column C). Some shifts are assigned points. I need to be able to add those points up if the employee is listed twice on the same day where one shift may be 2 points and another shift is on that same night. I found the XLOOKUP Function easy enough to use but run into trouble, like I said, when the employee appears twice on the same day. I created a formula to log the points for the shift in a separate column (in Column H). The employee name is used for the XLOOKUP Function to bring the value into another table.
Or, can I force the direction of the lookup function to start at the bottom of a column and go up instead of down since there can only be two occurrences of an employee on any given day?
Thank you!
Jul 23 2020 11:54 AM
Jul 25 2020 05:01 PM
@wdeets , sample with the solutions from the suggestions above...