More than a VLookup, Less than VB?

Hi Guys,

Long time Reader of the Forums, but first time poster! Keep up the awesome help!

My current problem is that Vlookup only looks at the top item in a data file that meets the condition and doesn't more on.

File 1 is a flat data file just for storing Team, Name, Values
File 2 will be a calculation file that's needs to be able to self-generate the list of name, then a vlookup can be used to bring the data across.

Any suggestions or is excel limited in this and VB script is needed?

File 1(The Data):
Ford Explorers Jan Jubb 6 1 2 0 2 0
Ford Explorers Joe Smith 6 4 2 0 2 0
Ford Explorers John Bloggs 6 1 2 0 2 0
Ford Mustangs Jim Mayer 0 0 0 0 10 1
Ford Mustangs Martin Jones 6 1 2 0 2 0
Ford Mustangs Michele Mamm 6 1 2 0 2 0
Ford Mustangs Ross Salo 6 1 2 0 2 1
Holden HSV Joy Jubes 6 2 2 0 2 1
Holden HSV Natalie Bunny 6 2 2 0 2 0
Holden HSV Kate Smith 6 4 2 0 2 0
Holden HSV Debbie Jones 6 0 2 0 2 0
Holden HSV Samantha Bloggs 6 1 2 1 2 0

File 2(The Calculation):
Team Name: Ford Explorers

First name from Data File from this team
Second Name from Data File from this team
Etc
Etc