Data Validation List based on another List

I'm not sure how this would work, but here's what I'm looking at.   I'm using Excel to track my outputs of certain materials, bought in different locations, however not every location offers every ...