I am trying to find a formula for our golf pools to reflect that a player that misses the cut will have his score for round 3 and 4 be one shot higher than the highest score for that round. So for example, in the sheet I've linked, Adam Scott shot a 79 in Round 3, so every player that missed the cut will get an 80 for Round 3. Zach Johnson's Round 3 score in cell F14 needs to reflect this. I am trying to keep it to just the two sheets if possible. I am using this formula for each round =IFERROR(INDEX(Leaderboard!H$2:H$100,Match($A14,Leaderboard!$B$2:$B$100,0)),"") and am hoping to be able to add the new formula to this one. Any help is appreciated. Thanks.
Bookmarks