Hi folks

I would really appreciate some help.

I would like to select a Managers name in one cell and depending on which one is chosen, it would display his/her team as a list from a dropdown from which you could then choose an employee.

I've attached a file - is this possible?

I have highlighted the cell in red (column C) I would like to see a list of team members in depending on which manager is selected (column B)

Escalations Log.xlsx

Thank you in advance