Forum Discussion
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 holiday pay periods, because the holiday adjustment amount depends on three variables: FTE, Shift Length and Y/N to working actual holiday. I've gotten a couple of easy xlookup formulas to work elsewhere in the spreadsheet, but I can't figure out how to get the correct holiday adjustment amount to autofill.
Hoping someone can help. Thank you!
This is the idea:
=XLOOKUP([@FTE]&[@[Shift Length]]&[@[Wrkd/RegSchd Holiday?]],Table8[FTE]&Table8[Shift]&Table8[Wrkd/Schd?],Table8[HH Adj],"Not found")
10 Replies
This is the idea:
=XLOOKUP([@FTE]&[@[Shift Length]]&[@[Wrkd/RegSchd Holiday?]],Table8[FTE]&Table8[Shift]&Table8[Wrkd/Schd?],Table8[HH Adj],"Not found")- I was out of the office yesterday afternoon and only now able to take a look at this. It works BEAUTIFULLY! And, I see what you did there. 🙂 Thank you so much for taking the time. This will be so helpful.
- You're welcome!
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
- Do you happen to have an anonymized sample you can upload or link via OneDrive, dropbox, etc. ?
- I kept getting an error message when trying to attach the file. Hoping you can access the link. Thank you!
I'm prompted to login and then once signed in, I receive an error message saying I'm not in the organization's directory.
You can send me the file directory through private message, if you like.
