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")
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.- Just sent. #organizationalsecurity
Received. I'm going to upload it here for others in case I'm not able to get to it today. Work can change at a moment's notice!