Golf Scorecard help!

Your file again with the handicap cells in column R now populated with INDEX/MATCH. So if you change the handicap value on the "Names and Handicaps" worksheet the values automatically update as do the determined info we fixed earlier.

As for what you did wrong when transferring it over? No idea, because I couldn't actually see any cells that looked like you'd tried to copy the formulas in.