So I have a table with clients' names. As my team expands, some clients are shifted from one team member to another one. My table looks like this
|Starting date||End date||Client name||Team member name|
Now, I'm doing an overview of all the clients with weekly revenue and I'd like to report which team member was responsible for the client that week. The table looks like this
|Week number||Client name||Revenues||Team member|
I cannot find how to automatically report the team member responsible for the client for that precise week base on the first table. I think it's a combination of IFS and VLOOKUPS but nothing I did worked so far.