Hi,

I have one spreadsheet with a list of components that go to make up a
product. There might be anything from 2 to 20 different components to a
product. There is a line per component, and in that row it will show which
product that component is part of, as well as a lot of other information
relating to that component.

In a second spreadsheet, I want to be able to type in a product and then for
each component that goes to make up that product to be listed on a separate
line underneath. Is this achievable and how?

Thanks for any help.

Will