Golf Scorecard help!

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!

Try this in cell X6 and copy to the right:

=INDEX(B$2:B$37,MATCH($AE$4,$A$2:$A$37,0))

Is that what you mean?

BSB

Thanks so much!! Yes this is great.

How can I get rid of the zero's(0) that keep popping up in the blanks?

And, how can I get the cell to update if I change the handicap?

Originally Posted by BadlySpelledBuoy

Try this in cell X6 and copy to the right:

=INDEX(B$2:B$37,MATCH($AE$4,$A$2:$A$37,0))

Is that what you mean?

BSB

If you change the handicap in cell AE4 then the values should change to reflect that. If they don't, make sure you have "Auto Calculate" turned on.

As for the zeros, you could hide them with conditional formatting, use the option to not show zeroes in cells or change the formula to :

=IF(INDEX(B$2:B$37,MATCH($AE$4,$A$2:$A$37,0))=0,"",INDEX(B$2:B$37,MATCH($AE$4,$A$2:$A$37,0)))

and drag it to the right again.

Great that worked on my test page. I have the code plugged in but it isnt working on the scorecard itself.
Here is the new document. 2014 Scorecards TEST FOR HANDICAP.xls

Thanks for your help, this is great!

All done.

For info, you could also use INDEX/MATCH or VLOOKUP to populate the tee numbers and handicap numbers from the "Names and Handicaps" worksheet. That way if you change the names, they would update too. Just makes things easier for you and eliminates the human error side of things.

You are amazing!!! Thanks so much. Not sure how to do the Index/Match or VLookup for the handicaps. Hopefully I'll get it soon!

Can you tell me what I did wrong when I transferred the code over? Just trying to understand the problem. Thanks again!

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.