It relates to data on another spreadsheet.

I want to be able to type in a product, and for all the components that go
to make up that product then to be listed (one per row) underneath. The other
spreadsheet contains a list of every component and what product it relates to.

Will