I am having trouble with the formula on the attached sheet. This is for a seniors golf game. The entry in B4,B8,B12 etc is the active input data (the players hcp). I want the strokes in the Vlookup table for the appropriate HCP to be entered in E1 thru V1 as per the color coding. I keep getting zeros and do not know why. Any suggestions would be much appreciated.
In E4, and copy right...
You should be able to copy the formula to other players, but I noticed for player "brown" the HCP value is on the Gross row as are the "pinkish" cells. I believe you need to move that all down one row.
Please Login or Register to view this content.
Many thanks for your help. All us old guys appreciate it.
You're welcome!
Here is another option...
=VLOOKUP($B4,$Y$5:$AQ$40,COLUMN()-3,FALSE)
copied across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is another option...
=VLOOKUP($B4,$Y$5:$AQ$40,COLUMN()-3,FALSE)
copied across
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks