INDEX/MATCH Lookup based on Data from another sheet

[mlbdc2012]

In my attached worksheet, I have a set of names with a designated team assigned to some of them. For the players assigned a team, I would like them to populate to the correct team on the Live Roster Grid sheet matched up with the position they play with the corresponding position from column H of the Draft Board.

Teams 1-10 work great with my formula but I can't seem to get teams 11-20 to populate with the same formula. Worksheet attached. Thanks!

[mlbdc2012]

I think it's something super small in my formula just to tell it to look up a different row but I'm having the hardest time figuring it out. Any help would be great. Thank you!

[mlbdc2012]

Still looking for help on this topic if anyone can help. Thanks!

[mlbdc2012]

Got to hit a deadline tomorrow morning with this project, hopefully someone can help me with this issue, I'm sure it's something super small I'm just such a novice at Excel that the littlest thing can throw me off my path for hours.

[FDibbins]

Change that last part to this...
COUNTIF($B$49:$B90,$B49))),"")

[mlbdc2012]

Change that last part to this...
COUNTIF($B$49:$B90,$B49))),"")

When I enter this formula it half works, it picks up Jose Altuve, who should be placed at 2B for team 11 which it does, but for some reason it doesn't pick up SP Zack Greinke for Team 11. Any idea why? Thanks

[FDibbins]

oops I didnt get that last part right...
=IFERROR(INDEX('Draft Board'!$C$31:$C$1104,SMALL(IF(('Draft Board'!$I$31:$I$1104=TRIM(C$48))*('Draft Board'!$H$31:$H$1104=TRIM($B49)),ROW('Draft Board'!$I$31:$I$1104)-ROW('Draft Board'!$I$31)+1),COUNTIF($B$49:$B49,$B49))),"")

[mlbdc2012]

oops I didnt get that last part right...
=IFERROR(INDEX('Draft Board'!$C$31:$C$1104,SMALL(IF(('Draft Board'!$I$31:$I$1104=TRIM(C$48))*('Draft Board'!$H$31:$H$1104=TRIM($B49)),ROW('Draft Board'!$I$31:$I$1104)-ROW('Draft Board'!$I$31)+1),COUNTIF($B$49:$B49,$B49))),"")

Awesome! Thanks very much

[FDibbins]

Glad we finally got it resolved for you, and thanks for the feedback

[mlbdc2012]

Glad we finally got it resolved for you, and thanks for the feedback

Thanks FDibbins! You were helping me with my other thread also, still haven't got that one finished. Take a look if you get a chance, appreciate your help!