I am new to the site as of today. I am building out an excel for a golf league and I have ran into a lil problem. What I am trying to do is pull in the handicap for each hole. I have succeeded with the formula. But the #1 handicap hole is referencing the vlookup name (which is 5 for the handicap). Instance if I have a 5 handicap in the league the output should be -1 for the first 5 hardest holes. It is skipping over the 1 handicap hole and just putting in 5 as what the handicap is and giving the 6th handicap hole a -1.
All your help would be much appreciated in helping me figure out what I am doing wrong.
The formula I am using is:
=VLOOKUP($AS$10,Sheet1!$A$4:$J$21,HLOOKUP(AT9,AT9:BB9,1,FALSE),FALSE)
Here is a glimpse of what my excel sheet shows:
<tbody>
</tbody><colgroup><col span="2"><col span="6"><col><col span="2"></colgroup>
Thanks again for all your help!
-John
All your help would be much appreciated in helping me figure out what I am doing wrong.
The formula I am using is:
=VLOOKUP($AS$10,Sheet1!$A$4:$J$21,HLOOKUP(AT9,AT9:BB9,1,FALSE),FALSE)
Here is a glimpse of what my excel sheet shows:
Marsh Oaks (back) | ||||||||||
Hole | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |
Par | 4 | 3 | 5 | 4 | 4 | 3 | 4 | 5 | 4 | |
Handicap | 3 | 8 | 6 | 9 | 7 | 5 | 1 | 2 | 4 | |
JZ | 5 | -1 | 0 | -1 | 0 | 0 | -1 | 5 | -1 | -1 |
<tbody>
</tbody><colgroup><col span="2"><col span="6"><col><col span="2"></colgroup>
Thanks again for all your help!
-John