Excel 2007 : Extract multiple matches based on one criteria

I'm guessing there's an IF statement plus a VLOOKUP formula I can use in the attached spreadsheet, but I don't know what it is and am wondering if anyone would like to help.

Two tabs: "701" and "pump list"
Goal: To get a list of pumps from "pump list" tab populated in column A of the "701" tab, but ONLY of the pump listed on the "pump list" tab has a 701 next to it. Empty cells should have nothing listed in them (as opposed to a NA or a zero).

What I'm trying to do is make scheduling production easier by dropping regularly changing data in a 'data dump' tab and using formulas to drive my schedule. I included a JPEG of what it should look like when it's done... but in the JPEG I just copied and pasted the values, where I ultimately need a formula to populate the cells.

Thank you for any / all help you can offer! You guys helped me out before and I'm so very grateful for your support.

Jenn

In D2 of pump list sheet enter:

=IF(B2=701,COUNT(D$1:D1)+1,"")

copied down

in E2 enter

=MAX(D:D)

Then in 701 sheet A4:

=IF(ROWS($A$1:$A1)>'pump list'!$E$2,"",INDEX('pump list'!A:A,MATCH(ROWS($A$1:$A1),'pump list'!$D:$D)))

and in B4:

=IF(ROWS($A$1:$A1)>'pump list'!$E$2,"",INDEX('pump list'!C:C,MATCH(ROWS($A$1:$A1),'pump list'!$D:$D)))

both copied down to the bottom of the table.