Hi,

In my added example I have a red table with an item code, warehouse code and a warehouse location code.
In the blue table I have two lookup lists with unique warehouses and warehouse locations, that I retrieved from an SQL database.

I would need a dependent data validation for the grey cells in column G, so that in G3 I can only choose from [001] and [002], since they belong to warehouse 1.
How would I do that ?

Thanks for helping me out here..

Example dependent dropdown.xlsx