Quote:
Originally Posted by pstrickert
If I create a .txt file with player ID, year, and three-letter team abbreviation, the players import to the proper teams just fine.
|
Thanks for the quick response. Then the link I sent you should work. You've got to add a space + year at the end of the team name. Only way I could make sure vlookup didn't get confused and got the correct team id right. I'll update the original file so the year is no longer needed once I'm positive it works.
Edit: Got to keep the year after the team name as I looked at the teams.csv and some have the same name, but different id so the year is needed. I've updated the file. Updated the comment in Enter team name column.