Hi, I'm working on a tournament bracket and need help with a formula. My sheet is going to be something like this column A=Team1 and column B=Team2. I have a have a formula created to pick the winner and enter that team name in column C which is the winner column. Now I need some kind of formula, maybe an if then statement, to fill column D which will be the loser column. Example would be if Team 2 is in the winner and in column C then it would automatically put Team1 as the the loser in column D. I'm using countif statements on another sheet to show wins/losses records for each team. Thanks