I am trying to plug in handicaps on a scorecard based off a table and I have no clue how to generate a formula to get it to do what I want it to do.

So I need it to determine that if someone has a handicap of 21(column), then it will plug in the determined (row) information.

Scorecard test.xlsx

Thanks for your help!