Parts list based on Equipment

I am trying to create a way of generating parts needed in inventory based on what equipment an area may have.

For Example:

I have several convenience stores in various states. 2 Stores have 1 type of fountain, 1 store a another and 3 have yet a third type.

How can I select the piece of equipment and then generate a list of parts needed to maintain that equipment.

I am still very new to spreadsheets and have no experience with arrays and table other than old school BASIC (yea I'm that old).

Appreciate any help.

Thanks

Radical