Hello,

I am hoping someone might be able to help with this. I am trying to come up with a sheet for my Fantasy Football league's draft. I have one worksheet that has the entire draft. Then I have a worksheet for each team. This has a table that autopopulates from the original draft, showing who each team has drafted. Also, there is another table on this worksheet that shows the full roster for the team.

Here's the problem. We draft multiple players at a couple of positions. So, I have been able to use the IF function to scan the data table for position players. (i.e. =IF(H6="QB",G6, IF(H7="QB", G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB", G10, IF(H11="QB", G12, IF(H13="QB", G13)))))))
So that it will autopopulate the QB position on the table. The problem I have is with the positions we draft more than one of. So for RB, it will autopopulate from the draft table, but it will put the first RB selcted at both cells.

Is there some way to have the first RB cell search through the data table and autopopulate. And then have the second RB cell compare itself with the first cell, and put in the next player?

Thank you.