Hey everyone, if anyone could help me with this that would be great.

I have a sheet that contains around 400 employees, including their managers that they report to. Every week it is updated with changes to different teams, new hires, terminations, etc. and I just paste the new data with the date of the change on the same sheet.
I also have another sheet where I keep track of customer credit requests that each employee submits and the date that they submit them.
My question is, I need to have the name of the employee's manager populate next to their name, and it has to pull from the sheet of all total employees. It also has to pull from who their manager was when they actually submitted the credit request. Is there a way to use a vlookup that is dependent on two different values (the name of the employee and the date of his request)? I've tried Index and Match, but can't get them to work.
Thanks