Look up function

[nguyenal07]

I created a drop down menu on an excel spreadsheet. Everytime I click a different drop down manager name, I want the cells below it (Employees) to automatically change to what ever employee that manager have. I have a table imported from access on sheet (called table).

I want to have some kind of look up that return "the unique employee name" everytime I change the manager drop down name.

For more details please see the attached file.

Thank you very much for your help.