Hi,

I am working on a large register of equipment and have a problem.

I need to create a list automatically based on the contents in one cell. I
have a equipment register on one sheet (Sheet 1) and wish a list to be
automatically generated via the info in a cell on Sheet 2, ive tried to show
what I mean below.

Sheet 1 data:
A B C D
1 Drill Yellow Parent Blue
2 Drill Yellow Child Blue
3 Drill Yellow Child Blue
4 Saw Black Parent Silver
5 Drill Yellow Parent Red
6 Hammer Brown Parent Hook


Sheet 2 data:
A B C D
1 Drill Parent
2
3 Drill Yellow Parent Blue
4 Drill Yellow Parent Red
5
6




A1 & B1 have the criteria i.e Drill & Parent, the list I want in generated
is shown from A3 down and across

What formula would I need to do this?

Many thanks in advance,

Chucks