Ok, give this a try.
While, both books are open, in the Tooling workbook, in H2 enter:
=IF(AND(A2='[Test.xlsx]Pattern Equipment'!$H$2,B2='[Test.xlsx]Pattern Equipment'!$I$8),COUNT(H$1:H1)+1,"")
and copy down.
In I2 enter:
Then in the Test Workbook, in A8 enter:
=IF(ROWS($A$1:$A1)>Tooling.xlsx!$I$2,"",INDEX(Tooling.xlsx!C:C,MATCH(ROWS($A$1:$A1),Tooling.xlsx!$H:$H)))
and copy down as far as you can go.
Then copy across to column G.
Note you will need to change the reference after the INDEX to match up. This is because you are using merged columns (which is usually frowned upon).
In I9 enter:
copied down.
Bookmarks