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

I think i attached sample, but if for some reason you cantsee it, the data is like this:

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

[JeteMc]

Hello scutler3 and Welcome to Excel Forum.
Try the following formulas
For draft pick:

Please Login or Register  to view this content.

For player name:

Please Login or Register  to view this content.

For salary (simple):

Please Login or Register  to view this content.

Let us know if you have any questions.

[Gregb11]

Since you have O365, you can use the new Dynamic Array Formulas for this. (And by the way, I would suggest you put your data in an Excel Table instead of putting in the headers every 33 rows).
For Draft pick:
=FILTER('Draft Order'!A:A,'Draft Order'!B:B=Roster!D1,"")
For player name and Salary (just 1 formula needed - in fact, if you put all 3 columns next to each other, you would only need to enter the formula in 1 cell and all the values would populate):
=FILTER('Draft Order'!C:D,'Draft Order'!B:B=Roster!D1,"")