Forum Discussion
Solved
Unsure of how to utilize xlookup & IF statements to get my spreadsheet to work
I have a simple spreadsheet I'm putting together to help with payroll submissions for salaried non-traditional shift employees and employees <full-time. I'm having difficulty when it comes to ho...
This is the idea:
=XLOOKUP([@FTE]&[@[Shift Length]]&[@[Wrkd/RegSchd Holiday?]],Table8[FTE]&Table8[Shift]&Table8[Wrkd/Schd?],Table8[HH Adj],"Not found")
https://kumed-my.sharepoint.com/:x:/r/personal/fellerman_kumc_edu/Documents/Exempt_KronosTemplate.xlsx?d=w81aa3b21b835479499d6dbe652996e50&csf=1&web=1&e=3DKz2U&nav=MTVfezJCRTU1QjlCLTcxQ0UtNDBBRS1BNDEyLThFNzM5N0NDODI2NH0