On a fantasy football draft excel sheet, I have a list of all the players. Next to that, I will input the teams that draft them.
On a separate sheet, I would like a column for each team listing the players that they drafted.
It doesn't seem like it should be that hard, but I can't seem to get it to work.

Any help would be appreciated.