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.
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?
Perhaps it shall be like