Forum Discussion
Complicated lookup
I have tried using v/xlookup or index&match to return for shift start time (will do the same for shift end) based on events in a shift for multiple employees. Simple normally, but these return the fi...
Does the attached example match what you want to do?
Not quite, I probably didn’t explain very well! Thanks for giving it a go. Couldn’t find a simple way of doing I now have a long formula including a couple of IFs, ISERROR, VLOOKUP, and FILTER!