Hello : )

I am trying to make a lot of data entry standardized in order to speed up entry and ensure consistency in the data. I am using excel 2016.

I have a list of restaurant groups (McDonalds, Costa etc) in column A which I would like as a drop down list when I click on the cell. Once I select the relevant restaurant chain I would like the cell populated. Then if I move across the B column I would like it to only show the relevant venue addresses for that chain.

I have tried to do this using Data validation but Im having trouble getting the B column to only show relevant restaurant chain addresses and not all restaurant addresses. I believe the data is best put into another sheet as the addresses may change from time to time.

Any help would be great, THANK YOU
Fluidnick