Multiple Fields pulling into a summary form

[scutler3]

Here is some sample data. I am trying to take this spreadsheet and pull the player name and salary to a summary form for that team. Example, Lewisberry chose Hank Aaron in rd 1 and Bill Castro in rd 2. I want the data to populate on a summary page for Lewisberry that shows their players and the salaries

Here is a sample

PICK # FRANCHISE Player Name SALARY
1 Lewisberry AARON, Hank $20.20
2 Jack Street AASE, Don $2.40
3 Middle Channel ABBOTT, Jim $4.90
4 Menomonee ABERNATHY, Ted $9.00
5 Cincinnati AKER, Jack $1.60
6 Las Vegas ALEXANDER, Pete (Grover Cleveland) $19.00
7 Coastline ALBERS, Matt $1.00
8 Fantomz BECK, Rod $2.90
9 Madison East ADAMS, Babe $15.90
10 New Westminster BETANCOURT, Rafael $3.30
11 Hollywood YOUNG, Cy $16.10
12 Kansas City A's TROUT, Dizzy $12.60
13 Purry SANTANA, Johan $15.10
14 Clockwork ADCOCK, Joe $5.10
15 Iowa AFFELDT, Jeremy $2.20
16 Wainwright AGEE, Tommie $1.20
17 Nags Head AGUILERA, Rick $6.10
18 Climax AGUIRRE, Hank $5.40
19 Indiana AIKENS, Willie $0.50
20 Detroit ALEXANDER, Doyle $10.60
21 San Tan Valley ALEXANDER, Dale $0.50
22 Hoboken ALFONZO, Edgardo $5.30
23 Chicago ALLEN, Cody $1.10
24 Kansas City Blues ALLEN, **** $18.20
25 Wrigleyville ALLEN, Johnny $11.00
26 Pigtown BAKER, Homerun $15.50
27 West Michigan BALFOUR, Grant $2.40
28 Boston BALL, Diamond (Walter) $3.20
29 Fort Worth BANCROFT, Dave $8.30
30 Virginia BANDO, Sal $9.70
31 Fire Lake BANKHEAD, Sam $1.10
32 Motown BANKS, Ernie $10.60
PICK # FRANCHISE Player Name SALARY
33 Motown BARFIELD, Jesse $4.20
34 Fire Lake BARNES, Jesse $10.50
35 Virginia BARNHILL, Impo (David) $0.50
36 Fort Worth BARRETT, Jimmy $0.90
37 Boston BARTELL, **** $6.30
38 West Michigan BASSLER, Johnny $0.50
39 Pigtown BATES, Johnny $7.40
40 Wrigleyville BATTEY, Earl $1.20
41 Kansas City Blues BAUER, Hank $4.80
42 Chicago BAY, Jason $5.10
43 Hoboken BAUTISTA, Jose $9.10
44 San Tan Valley BAYLOR, Don $7.30
45 Detroit BEAUMONT, Ginger $10.00
46 Indiana BECK, Rod $2.90
47 Climax BECKER, Beals $0.50
48 Nags Head BECKERT, Glenn $1.90
49 Wainwright BECKETT, Josh $11.60
50 Iowa BECKLEY, Jake $3.10
51 Clockwork BECKWITH, John $9.90
52 Purry BEDROSIAN, Steve $5.30
53 Kansas City A's BEGGS, Joe $1.90
54 Hollywood BELANGER, Mark $0.50
55 New Westminster BELL, Buddy $6.60
56 Madison East BELL, Cool Papa (James) $10.00
57 Fantomz BELL, George $5.00
58 Coastline BELL, Gus $5.40
59 Las Vegas BELL, Heath $1.10
60 Cincinnati BELL, William $1.10
61 Menomonee BELLE, Albert $11.20
62 Middle Channel BELT, Brandon $3.40
63 Jack Street GAGNE, Eric $4.90
64 Lewisberry CASTRO, Bill $0.50

 

[Toadstool]

Hi Scutler3,

This should work,

Book1
	A	B	C	D	E	F	G	H	I	J
1	PICK #	FRANCHISE	Player Name	SALARY			Franchise	No. of Picks	Player	Salary
2	1	Lewisberry	AARON, Hank	$20.20			Lewisberry	2	AARON, Hank	$20.20
3	2	Jack Street	AASE, Don	$2.40					CASTRO, Bill	$0.50
4	3	Middle Channel	ABBOTT, Jim	$4.90
5	4	Menomonee	ABERNATHY, Ted	$9.00
6	5	Cincinnati	AKER, Jack	$1.60
7	6	Las Vegas	ALEXANDER, Pete (Grover Cleveland)	$19.00
8	7	Coastline	ALBERS, Matt	$1.00
9	8	Fantomz	BECK, Rod	$2.90
10	9	Madison East	ADAMS, Babe	$15.90
11	10	New Westminster	BETANCOURT, Rafael	$3.30
12	11	Hollywood	YOUNG, Cy	$16.10
13	12	Kansas City A's	TROUT, Dizzy	$12.60
14	13	Purry	SANTANA, Johan	$15.10
Teams

Cell Formulas
Range	Formula
H2	H2	=COUNTIF($B$2:$B$9999,$G$2)
I2:J14	I2	=IF(ROW()-ROW($I$1)>$H$2,"",INDEX(C$2:C$9999,AGGREGATE(15,6,$A$2:$A$9999/($B$2:$B$9999=$G$2),ROW()-ROW($I$1))))