I'm trying to cascade vlookups based off of one entry. I've been using Vlookup for a long time now and know it has a few drawbacks, and I'm hitting both of them with this example. I know it's not the proper formula to use so I'm looking for your help.
What I want to do is type in a quarterback's name in to A2. that then pulls that QB's data out of one matrix and sticks it on the second row. I then want to pull all of the intended receivers for that QB's team in rows 6-20, by matching their team to the quarterback's. In this case, I'm using Matthew Stafford from Detroit, and then looking for Detroit in the receivers matrix.
Problem 1: I know its possible, but I don't know how to search the second column in a vlookup, but still pull the players' names from the first column.
Problem 2: If I do a basic vlookup with multiple matches, it always displays the first one. Is there any way to have it go down the list and enter them in order?
Excel 2016 (Mac) 32 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="align: right"]592[/TD]
[TD="align: right"]398[/TD]
[TD="align: right"]67.2[/TD]
[TD="align: right"]4262[/TD]
[TD="align: right"]7.2[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]5.4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]251[/TD]
[TD="align: right"]97[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]#REF![/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]495[/TD]
[TD="align: right"]296[/TD]
[TD="align: right"]59.8[/TD]
[TD="align: right"]3837[/TD]
[TD="align: right"]7.8[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]7.1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]284[/TD]
[TD="align: right"]99.4[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]380[/TD]
[TD="align: right"]242[/TD]
[TD="align: right"]63.7[/TD]
[TD="align: right"]3035[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5.3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]212[/TD]
[TD="align: right"]99.4[/TD]
[TD="align: center"]17[/TD]
[TD="bgcolor: #FFFF00"]Matthew Stafford[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="bgcolor: #FFFF00, align: right"]592[/TD]
[TD="bgcolor: #FFFF00, align: right"]398[/TD]
[TD="bgcolor: #FFFF00, align: right"]67.2[/TD]
[TD="bgcolor: #FFFF00, align: right"]4262[/TD]
[TD="bgcolor: #FFFF00, align: right"]7.2[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #FFFF00, align: right"]5.4[/TD]
[TD="bgcolor: #FFFF00, align: right"]13[/TD]
[TD="bgcolor: #FFFF00, align: right"]2.2[/TD]
[TD="bgcolor: #FFFF00, align: right"]57[/TD]
[TD="bgcolor: #FFFF00, align: right"]44[/TD]
[TD="bgcolor: #FFFF00, align: right"]251[/TD]
[TD="bgcolor: #FFFF00, align: right"]97[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"]470[/TD]
[TD="align: right"]307[/TD]
[TD="align: right"]65.3[/TD]
[TD="align: right"]3486[/TD]
[TD="align: right"]7.4[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]4.3[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]235[/TD]
[TD="align: right"]95.4[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]23[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]1,304[/TD]
[TD="align: right"]12.42[/TD]
[TD="align: right"]81.5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]177[/TD]
[TD="align: right"]479[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]24[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]1,450[/TD]
[TD="align: right"]15.1[/TD]
[TD="align: right"]96.7[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]25[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]1,088[/TD]
[TD="align: right"]11.57[/TD]
[TD="align: right"]72.5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]384[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #FFFF00"]Golden Tate[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="bgcolor: #FFFF00, align: right"]16[/TD]
[TD="bgcolor: #FFFF00, align: right"]90[/TD]
[TD="bgcolor: #FFFF00, align: right"]813[/TD]
[TD="bgcolor: #FFFF00, align: right"]9.03[/TD]
[TD="bgcolor: #FFFF00, align: right"]50.8[/TD]
[TD="bgcolor: #FFFF00, align: right"]43[/TD]
[TD="bgcolor: #FFFF00, align: right"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]50[/TD]
[TD="bgcolor: #FFFF00, align: right"]128[/TD]
[TD="bgcolor: #FFFF00, align: right"]533[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]27[/TD]
[TD="bgcolor: #FFFF00"]Calvin Johnson[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="bgcolor: #FFFF00, align: right"]16[/TD]
[TD="bgcolor: #FFFF00, align: right"]88[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,214[/TD]
[TD="bgcolor: #FFFF00, align: right"]13.8[/TD]
[TD="bgcolor: #FFFF00, align: right"]75.9[/TD]
[TD="bgcolor: #FFFF00, align: right"]57[/TD]
[TD="bgcolor: #FFFF00, align: right"]9[/TD]
[TD="bgcolor: #FFFF00, align: right"]65[/TD]
[TD="bgcolor: #FFFF00, align: right"]149[/TD]
[TD="bgcolor: #FFFF00, align: right"]296[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]28[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]952[/TD]
[TD="align: right"]10.94[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]468[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #E0E0F0"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]B2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]C2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,3,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]D2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,4,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]E2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,5,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]F2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,6,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]G2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,7,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]H2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,8,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]I2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,9,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]J2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,10,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]K2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,11,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]L2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,12,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]M2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,13,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]N2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,14,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]O2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,15,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]B6[/TH]
[TD="align: left"]=INDEX(A23:L28,MATCH(B2,B23:B28,1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
What I want to do is type in a quarterback's name in to A2. that then pulls that QB's data out of one matrix and sticks it on the second row. I then want to pull all of the intended receivers for that QB's team in rows 6-20, by matching their team to the quarterback's. In this case, I'm using Matthew Stafford from Detroit, and then looking for Detroit in the receivers matrix.
Problem 1: I know its possible, but I don't know how to search the second column in a vlookup, but still pull the players' names from the first column.
Problem 2: If I do a basic vlookup with multiple matches, it always displays the first one. Is there any way to have it go down the list and enter them in order?
Excel 2016 (Mac) 32 bit
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Matthew Stafford | |||||||||||||||
| Golden Tate | |||||||||||||||
| Calvin Johnson | |||||||||||||||
| QUARTERBACKS | |||||||||||||||
| Player | Team | Att | Cmp | Pct | Yds | YPA | TD | TD% | Int | Int% | Lg | Sack | Loss | Rate | |
| Cam Newton | Car | 74t | |||||||||||||
| Tyrod Taylor | Buf | ||||||||||||||
| Alex Smith | KC | 80t | |||||||||||||
| RECIEVERS | |||||||||||||||
| Player | Team | Gms | Rec | Yds | Avg | YPG | Lg | TD | FD | Tar | YAC | ||||
| Demaryius Thomas | Den | 72t | |||||||||||||
| Odell Beckham Jr. | NYG | 87t | |||||||||||||
| Delanie Walker | Ten | 61t | |||||||||||||
| Jordan Reed | Was | ||||||||||||||
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="align: right"]592[/TD]
[TD="align: right"]398[/TD]
[TD="align: right"]67.2[/TD]
[TD="align: right"]4262[/TD]
[TD="align: right"]7.2[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]5.4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]251[/TD]
[TD="align: right"]97[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]#REF![/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]7[/TD]
[TD="bgcolor: #FFFF00, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]495[/TD]
[TD="align: right"]296[/TD]
[TD="align: right"]59.8[/TD]
[TD="align: right"]3837[/TD]
[TD="align: right"]7.8[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]7.1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]284[/TD]
[TD="align: right"]99.4[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]380[/TD]
[TD="align: right"]242[/TD]
[TD="align: right"]63.7[/TD]
[TD="align: right"]3035[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5.3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]212[/TD]
[TD="align: right"]99.4[/TD]
[TD="align: center"]17[/TD]
[TD="bgcolor: #FFFF00"]Matthew Stafford[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="bgcolor: #FFFF00, align: right"]592[/TD]
[TD="bgcolor: #FFFF00, align: right"]398[/TD]
[TD="bgcolor: #FFFF00, align: right"]67.2[/TD]
[TD="bgcolor: #FFFF00, align: right"]4262[/TD]
[TD="bgcolor: #FFFF00, align: right"]7.2[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #FFFF00, align: right"]5.4[/TD]
[TD="bgcolor: #FFFF00, align: right"]13[/TD]
[TD="bgcolor: #FFFF00, align: right"]2.2[/TD]
[TD="bgcolor: #FFFF00, align: right"]57[/TD]
[TD="bgcolor: #FFFF00, align: right"]44[/TD]
[TD="bgcolor: #FFFF00, align: right"]251[/TD]
[TD="bgcolor: #FFFF00, align: right"]97[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"]470[/TD]
[TD="align: right"]307[/TD]
[TD="align: right"]65.3[/TD]
[TD="align: right"]3486[/TD]
[TD="align: right"]7.4[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]4.3[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]235[/TD]
[TD="align: right"]95.4[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]23[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]1,304[/TD]
[TD="align: right"]12.42[/TD]
[TD="align: right"]81.5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]177[/TD]
[TD="align: right"]479[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]24[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]1,450[/TD]
[TD="align: right"]15.1[/TD]
[TD="align: right"]96.7[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]590[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]25[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]1,088[/TD]
[TD="align: right"]11.57[/TD]
[TD="align: right"]72.5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]384[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]26[/TD]
[TD="bgcolor: #FFFF00"]Golden Tate[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="bgcolor: #FFFF00, align: right"]16[/TD]
[TD="bgcolor: #FFFF00, align: right"]90[/TD]
[TD="bgcolor: #FFFF00, align: right"]813[/TD]
[TD="bgcolor: #FFFF00, align: right"]9.03[/TD]
[TD="bgcolor: #FFFF00, align: right"]50.8[/TD]
[TD="bgcolor: #FFFF00, align: right"]43[/TD]
[TD="bgcolor: #FFFF00, align: right"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]50[/TD]
[TD="bgcolor: #FFFF00, align: right"]128[/TD]
[TD="bgcolor: #FFFF00, align: right"]533[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]27[/TD]
[TD="bgcolor: #FFFF00"]Calvin Johnson[/TD]
[TD="bgcolor: #FFFF00"]Det[/TD]
[TD="bgcolor: #FFFF00, align: right"]16[/TD]
[TD="bgcolor: #FFFF00, align: right"]88[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,214[/TD]
[TD="bgcolor: #FFFF00, align: right"]13.8[/TD]
[TD="bgcolor: #FFFF00, align: right"]75.9[/TD]
[TD="bgcolor: #FFFF00, align: right"]57[/TD]
[TD="bgcolor: #FFFF00, align: right"]9[/TD]
[TD="bgcolor: #FFFF00, align: right"]65[/TD]
[TD="bgcolor: #FFFF00, align: right"]149[/TD]
[TD="bgcolor: #FFFF00, align: right"]296[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]28[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]952[/TD]
[TD="align: right"]10.94[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]468[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
Sheet1
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #E0E0F0"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]B2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,2,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]C2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,3,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]D2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,4,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]E2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,5,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]F2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,6,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]G2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,7,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]H2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,8,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]I2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,9,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]J2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,10,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]K2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,11,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]L2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,12,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]M2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,13,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]N2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,14,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]O2[/TH]
[TD="align: left"]=VLOOKUP($A$2,$A$15:$O$18,15,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]B6[/TH]
[TD="align: left"]=INDEX(A23:L28,MATCH(B2,B23:B28,1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
