Dependent Drop Downs across multiple rows in a spreadsheet

Hello. I've been trying to create a spreadsheet that has a dependent dropdown column. However, all the guides and advice I've seen so far have been functional only when you only need a single cell or...