Do you want the first team 6 stats or the total of team 6 stats?

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
i have two sheets. on one sheet i have a column of about 100 team
numbers ranging in varying intervals from 1 to 1676. the other sheet
looks like this: (cell columns separated by - )

[team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ...
[team number 1] - [team 1 stat] - [team 1 stat] - [team 1 stat] ...
[team number 4] - [team 4 stat] - [team 4 stat] - [team 4 stat] ...
[team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ...
[team number 2] - [team 2 stat] - [team 2 stat] - [team 2 stat] ...

Note that team 6 appears in two locations. i need to take each team
number from my first sheet and find it in the other sheet with all the
stats so that i can export averages or totals to the sheet with only
the team numbers.

my problem is that i have a list of team numbers, but i don't know
what order they will appear in the stat sheet, because the matchups
are random.

How can i find the team in the stat list and export the stats to the
team list?