Sep 03 2020 11:28 PM
Hey guys,
im having problems with a XLOOKUP.
I want to know if the employees who logged 6 or more hours of delivery also logged a break (labourlaw compliance). The table contains log_date, user_name, task_name and log_time.
=XLOOKUP([@[log_date]]&[@[user_name]]&[task_name]="Break";[log_date]&[user_name]&[task_name];[Sum_log_time])
This is what i wrote so far, but i always get the #N/A-Error or sometimes #Value.
Does anyone know how to handle this?
Thanks!
P
Sep 04 2020 01:43 AM