Hello,
I'm working on a spreadsheet to automatically do the standings for our fantasy baseball league. I have it formatted where I can input each players weekly score on the scores tab and it will automatically populate the PF field for each team on their page, but I'm trying to automatically populate the PA field. If you look at the scores tab, Cajun Coonasses scored 347.0 points in week one and that total appears on the Coonasses tab, in field E3. What I am trying to do is match the week number and match it to the team that they play each week. For example, Cajun Coonasses plays King of Queens and Thundermutts in week 2. Ideally, I want to use excel to look at the scores for each team and find the opponent each week and populate the FA field of each team.
Bookmarks