Dynamic Dropdown list based on the value entered in the adjacent cell

Hi there!

I need help in populating a dropdown list based on a value entered in an adjacent cell

In the sample workbook attached, I have sheets - Employee, Location, and License.

The employee Details are added manually in the Employee sheet. Then For each employee ID, one or more locations are added manually in the Location Sheet.

Now, what I am trying to achieve is - when I select an employee ID in License Tab A2, then in the cell B2, the dropdown list should show only those locations which are available for the employee ID selected (as per employee-location mapping done in Location sheet).

Thank you so much for your help!

Please see attached, is this what you had in mind?

I used a FILTER formula to bring back the relevant locations.

Cheers
Nico

Andrews_Sample filtered.xlsx

Sorry, couldn't tell from your post that you needed multiple lookups.

I've fixed it, it ain't pretty, but it works

Cheers
Nico

Andrews_Sample filtered fixed again.xlsx


"I didn't have time to give you a simple formula, so I gave you a complex formula." - Mark Twain / Cicero / Blaise Pascal

Thanks, Nico. This solved my problem.