Which Formula to Use?

[ZombieNation108]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> I'm thinking I need to use a combination of Index Array, Match, and possibly VLookUp to achieve this, but I could be completely wrong.
So I want to get the information from Draft Column C to populate in Sheet 1 Column B in the corresponding position relating to Sheet1 Column A & Sheet Draft Column B. If Sheet Draft Column B has duplicate values I want them to populate on Sheet1 Column B in the next available spot.

Example: Mike Napoli goes in Sheet1 Column B Row 2, Miguel Cabrera goes in Sheet1 Column B Row 7, Lucas Duda goes in Sheet1 Column B Row 13, and Derrek Lee goes in Sheet1 Column B Row 14. The 1’s are in column A of Sheet 1 because there are 12 groups that I’m looking to accomplish this for on Sheet 1.

And so on and so on.

Sheet: Draft
A B C
<table class="MsoNormalTable" style="width:205.5pt;mso-cellspacing:0in;mso-padding-alt:0in 0in 0in 0in" border="0" cellpadding="0" cellspacing="0" width="274"> <col style="mso-width-source:userset;mso-width-alt:768;width:16pt" width="21"><col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"><col style="mso-width-source:userset;mso-width-alt:7094;width:146pt" width="194"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt"> <td style="width:16.0pt;padding:0in 0in 0in 0in;height:15.0pt" width="21"> 1
</td> <td style="width:44.0pt;padding:0in 0in 0in 0in;height:15.0pt" width="59"> C
</td> <td style="width:146.0pt;padding:0in 0in 0in 0in;height:15.0pt" width="195"> Miguel Montero
</td> </tr> <tr style="mso-yfti-irow:1;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Mike Napoli
</td> </tr> <tr style="mso-yfti-irow:2;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Miguel Cabrera
</td> </tr> <tr style="mso-yfti-irow:3;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Lucas Duda
</td> </tr> <tr style="mso-yfti-irow:4;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Derrek Lee
</td> </tr> <tr style="mso-yfti-irow:5;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 2B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Brandon Phillips
</td> </tr> <tr style="mso-yfti-irow:6;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 2B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Ryan Roberts
</td> </tr> <tr style="mso-yfti-irow:7;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 3B
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Michael Young
</td> </tr> <tr style="mso-yfti-irow:8;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> SS
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Starlin Castro
</td> </tr> <tr style="mso-yfti-irow:9;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> SS
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Asdrubal Cabrera
</td> </tr> <tr style="mso-yfti-irow:10;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Dexter Fowler
</td> </tr> <tr style="mso-yfti-irow:11;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Brennan Boesch
</td> </tr> <tr style="mso-yfti-irow:12;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Yonder Alonso
</td> </tr> <tr style="mso-yfti-irow:13;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Brandon Belt
</td> </tr> <tr style="mso-yfti-irow:14;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Howard Kendrick
</td> </tr> <tr style="mso-yfti-irow:15;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> SP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Ian Kennedy
</td> </tr> <tr style="mso-yfti-irow:16;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> SP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Wandy Rodriguez
</td> </tr> <tr style="mso-yfti-irow:17;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> SP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Gavin Floyd
</td> </tr> <tr style="mso-yfti-irow:18;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Jonathan Papelbon
</td> </tr> <tr style="mso-yfti-irow:19;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Drew Storen
</td> </tr> <tr style="mso-yfti-irow:20;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Neftali Feliz
</td> </tr> <tr style="mso-yfti-irow:21;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> J.J. Putz
</td> </tr> <tr style="mso-yfti-irow:22;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Brandon League
</td> </tr> <tr style="mso-yfti-irow:23;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Kenley Jansen
</td> </tr> <tr style="mso-yfti-irow:24;mso-yfti-lastrow:yes;height:15.0pt"> <td style="padding:0in 0in 0in 0in;height:15.0pt"> 1
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:15.0pt"> Tyler Clippard
</td> </tr> </tbody></table>
Sheet 1
A B
<table class="MsoNormalTable" style="width:284.25pt;mso-cellspacing:0in;mso-padding-alt:0in 0in 0in 0in" border="0" cellpadding="0" cellspacing="0" width="379"> <col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"><col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"><col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"><col style="mso-width-source:userset;mso-width-alt:1133;width:23pt" width="31"><col style="mso-width-source:userset;mso-width-alt:914;width:19pt" width="25"><col style="mso-width-source:userset;mso-width-alt:1133;width:23pt" width="31"><col style="mso-width-source:userset;mso-width-alt:1718; width:35pt" span="2" width="47"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:12.0pt"> <td style="width:30.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="40"> <table class="MsoNormalTable" style="width:284.25pt;mso-cellspacing:0in;mso-padding-alt:0in 0in 0in 0in" border="0" cellpadding="0" cellspacing="0" width="379"> <col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"><col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"><col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"><col style="mso-width-source:userset;mso-width-alt:1133;width:23pt" width="31"><col style="mso-width-source:userset;mso-width-alt:914;width:19pt" width="25"><col style="mso-width-source:userset;mso-width-alt:1133;width:23pt" width="31"><col style="mso-width-source:userset;mso-width-alt:1718; width:35pt" span="2" width="47"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:12.0pt"> <td style="width:30.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="40"> <table class="MsoNormalTable" style="width: 157px; height: 576px;" border="0" cellpadding="0" cellspacing="0"> <col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"><col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.0pt"> <td style="width:30.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="40"> C
</td> <td style="width:88.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="117">
</td> </tr> <tr style="mso-yfti-irow:1;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> 1B
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:2;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> 2B
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:3;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> 3B
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:4;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> SS
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:5;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> 2B/SS
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:6;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> 1B/3B
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:7;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:8;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:9;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:10;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:11;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> OF
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:12;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Util
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:13;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:14;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:15;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:16;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:17;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:18;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Pos
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Player
</td> </tr> <tr style="mso-yfti-irow:19;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:20;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:21;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:22;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:23;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:24;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:25;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> P
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:26;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> SP
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:27;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> RP
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:28;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:29;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">
</td> </tr> <tr style="mso-yfti-irow:30;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">

</td> </tr> <tr style="mso-yfti-irow:31;mso-yfti-lastrow:yes;height:12.0pt"> <td style="padding:0in 0in 0in 0in;height:12.0pt"> Bench
</td> <td style="padding:0in 0in 0in 0in;height:12.0pt">

</td> </tr> </tbody></table> </td> <td style="width:88.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="117">
</td> <td style="width:31.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="41">
</td> <td style="width:23.0pt;padding:0in 0in 0in 0in;height:12.0pt" width="31">

​

</td> </tr> </tbody></table> </td> </tr> </tbody></table>

 

[ZombieNation108]

Any thoughts? Sorry if the columns look crappy. This is my first post.