John,

What is present in the intersection of the row and column to indicate that
the component is used in the product?

And shortened example with what you eventually want would help....

HTH,
Bernie
MS Excel MVP


"frustratedjohn" wrote in message
...
I have an array that has components as the top row and products as the
first
column. I want to be able to create a list for n aay given product of the
components contained in it, there could be several, i.e. say the product
is
flange assembly, it contains a flange bolts, nuts and washers, the row of
components has not only these components but sockets, elbows and tees.
Any
ideas on how this can be done? Any help would be greatly appreciated!