Confirmations.jpgDeal Packet.jpg

I couldn't get my excel files to attach here. So I had to attach screenshots.

The photo that has a header saying "Specifications of duplicated home serial number" is in an excel 2010 file called Deal Packet and this data is on a sheet named Dup. Home. The second photo without a header is also an excel 2010 file called Confirmations on a sheet called SD.

I am trying to get information from the Confirmation file to feed to the Deal Packet file when F2 of the deal packet matches the number in Confirmation column B. I have used Vlookup and Index/Match formulas but they are only returning the first line that matches. I need all rows that Deal Packet F2 matches Confirmation column B to feed over.

If the F2 and column B matches I need the following information to automatically feed:
Confirmation column E to feed to Deal packet column E.
Confirmation column F to feed to Deal Packet column F.
Confirmation column H to feed to Deal Packet column G.

Any help would be greatly appreciated!