Hi I have a function performing the task I want it to, but I am curious if anyone can think of a better and more efficient way of accomplishing the task.
The idea is to type an employee # into a table, and then attempt to find out if that employee has a scheduled shift today.
Employee shifts are located in 6 separate tables, so I have made a formula like:
=XLOOKUP([@Number],Table1[Emp '#],Table1[Start],XLOOKUP([@Number],Table2[Emp '#],Table2[Start],XLOOKUP([@Number],Table3[Emp '#],Table3[Start],XLOOKUP([@Number],Table4[Emp '#],Table4[Start],XLOOKUP([@Number],Table5[Emp '#],Table5[Start],XLOOKUP([@Number],Table6[Emp '#],Table6[Start],"not in today"))))))
This does achieve the desired outcome, but as mentioned I would like to know if there is a better way.
Thanks
The idea is to type an employee # into a table, and then attempt to find out if that employee has a scheduled shift today.
Employee shifts are located in 6 separate tables, so I have made a formula like:
=XLOOKUP([@Number],Table1[Emp '#],Table1[Start],XLOOKUP([@Number],Table2[Emp '#],Table2[Start],XLOOKUP([@Number],Table3[Emp '#],Table3[Start],XLOOKUP([@Number],Table4[Emp '#],Table4[Start],XLOOKUP([@Number],Table5[Emp '#],Table5[Start],XLOOKUP([@Number],Table6[Emp '#],Table6[Start],"not in today"))))))
This does achieve the desired outcome, but as mentioned I would like to know if there is a better way.
Thanks