Dependant dropdown on a list; VBA or Native tools

Hi,

Please see attached, example of data:
I want a user to be able to select a Customer ID, which is a number they will always know as it relates two a customer record in our software platform.
Then based on this value addresses show up, but only ones where the customer ID is matching.

As on the spreadsheet provided, customers and their addresses are a one to many relationship, as we have multiple subsidiaries and warehouse, as do they etc. etc.

Most on the online articles show examples with a list of IDs, then a list for each ID, e.g.:
ID = Food Type; Meat, Veg, Fruit
Meat List; Chicken, Beef, Pork
Veg; Cucumber, Celery, Peas, Corn
Fruit; apply, orange, mango

Where as my data is in a full table form, and headed.

Please, please, please help would be appreciated.

Kind Regards
Luke

Hi Ford,

I did also attach an example? Can you not see it. Will attach again to make sure.

Regards
Luke