I'll start with what I am looking to accomplish with my sheet,
Our mens club skins games are capped at a 20 handicap, I am looking to take the gross scores from the left side and have the handicap applied to the proper holes and apply that to make a net scoresheet on the right. My formula works great for handicaps 1-18 taking off one stroke accordingly, but once i get to 19 and 20, the formula will no longer work for all holes, not just the ones rank 1st (4th hole) and 2nd hardest (12th Hole). Any help would be great Thanks

Skins Format.xlsx