title: Determine Win or Loss of each game and record to that teams list
body: <p>I have all my other formulas figured out but I'm stuck on 1 particular that actually produces the W or L.</p>
  <p><a href="https://i.stack.imgur.com/tt8IL.png" rel="nofollow noreferrer">The schedule</a></p>
  <p>What I'm trying to do on a separate sheet is, regardless of the home (left) or away (right) position, if the winner (team name) = A-row, put a W in B-row,C-row,etc. and if they lost, put an L.</p>
  <p>Schedule sheet is Home Team in A, @ symbol in B, Away Team in C, Time in D, E is Home score and F is Away score</p>
  <p>And here is what I'm trying to get as a final picture</p>
  <p><a href="https://i.stack.imgur.com/csxD4.png" rel="nofollow noreferrer">Tracker sheet</a></p>
  <p>The tracker sheet also powers the streak counter, but I have a working formula for that. (it works great when I manually enter W and L on the tracker)</p>
  <p>Thank you for taking the time to read this.</p>