DogWithWiFi
New Member
- Joined
- Jan 10, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Web
Hey all, I can't figure out how to pull this off with a single formula, or what the best approach might be (FILTER, INDEX & MATCH, ?).
I want to return a list of Names (and the associated Status) from all rows where: Any of the dates in D:F match the dynamic date in I3 and the Status in C matches the dynamic value in I2.
In my example, the list should return:
Bob | Approve
Chris | Approve
Kelly | Approve
Any help is appreciated - thanks!
I want to return a list of Names (and the associated Status) from all rows where: Any of the dates in D:F match the dynamic date in I3 and the Status in C matches the dynamic value in I2.
In my example, the list should return:
Bob | Approve
Chris | Approve
Kelly | Approve
Any help is appreciated - thanks!