Sep 11 2021 04:01 PM
Sep 11 2021 07:22 PM
You stated:
Hello. I have a table with a list of drivers in the 1st column and dates across the top.
The data within there indicates if the driver is on or off.
I'm trying to figure out if there's maybe a VLookup/HLookup combination formula (or maybe a different formula) to give a list of drivers that are on or off for a particular day.
The answer is yes you can, and since you're not sharing the geography of your data table and where the formula will be located at, I won't suggest a solution based on a guess.
cheers
Sep 11 2021 07:32 PM
@Heidi588 \\From what you've said, I'm guessing the new FILTER function would deliver the result you're seeking. Here's a video Microsoft produced that explains the function. It doe require the most recent version of Excel.
https://www.youtube.com/watch?v=9I9DtFOVPIg