Home

GOLF GAME WORKBOOK AUTOMATION

%3CLINGO-SUB%20id%3D%22lingo-sub-743394%22%20slang%3D%22en-US%22%3EGOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743394%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20workbook%20that%20can%20be%20used%20to%20figure%20who%20one%20the%20Golf%20Game.%20In%20Column%20B%20I%20have%20a%20list%20of%20names.%20In%20Column%20C%20I%20have%20the%20handicap%20associated%20with%20each%20name.%20I'm%20assuming%20the%20first%20step%20would%20be%20to%20build%20a%20Drop%20Down%20Box%20with%20all%20the%20names.%20When%20a%20name%20is%20selected%20I%20would%20think%20next%20to%20the%20name%2C%20in%20a%20separate%20cell%2C%20the%20handicap%20should%20appear.%20Any%20idea%20on%20how%20to%20make%20that%20happen%3F%20I've%20tried%20the%20V-LOOKUP%20Feature%20but%20can't%20get%20it%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-743394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743407%22%20slang%3D%22en-US%22%3ERe%3A%20GOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743407%22%20slang%3D%22en-US%22%3EYou%20certainly%20need%20to%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743449%22%20slang%3D%22en-US%22%3ERe%3A%20GOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESir%20this%20project%20is%20crazy%20but%20I'm%20trying%20to%20do%20it.%20I'm%20%22ok%22%20with%20excel.%20My%20company%20runs%20on%20it%20and%20I%20wrote%20all%20the%20programs.%20We%20have%20been%20in%20business%2030%20years.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20%22kid%22%20that%20lives%20in%20a%20small%20rural%20community%20in%20Georgia.%20There%20are%20a%20bunch%20of%20guys%20that%20play%20Golf%20together%20three%20times%20a%20week.%20After%20the%20Golf%20game%20they%20would%20sit%20for%20an%20hour%2C%20maybe%20two%2C%20figuring%20up%20their%20bets.%20This%20%22kid%22%20I%20mentioned%20has%20never%20played%20golf%20but%20he%20created%20something%20for%20them.%20If%20you%20go%20to%20helpshae.com%2Findex%20you%20will%20see%20what%20he%20created.%20We%20can't%20find%20this%20%22kid%22%20anymore%20and%20I'd%20like%20to%20duplicate%20what%20he's%20done%20but%20honestly%2C%20%22I%20can't%20even%20figure%20out%20how%20to%20start.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20program%20he%20wrote%20adjust%20handicaps%20depending%20on%20who's%20in%20the%20game%2C%20it%20figures%20all%20the%20bets.%20Personally%20I%20think%20the%20%22kid%22%20is%20a%20genius%20and%20if%20I%20could%20find%20him%20I%20would%20hire%20him!%20LOL%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20think%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744173%22%20slang%3D%22en-US%22%3ERe%3A%20GOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372017%22%20target%3D%22_blank%22%3E%40DaCrab%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%2C%20this%20formula%20in%20B2%20of%20the%20attached%20file%20will%20comply%20with%20your%20requirement%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIFNA(VLOOKUP(A2%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EPlayerTable%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E2%2C0)%2C%22Not%20Found%22)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754444%22%20slang%3D%22en-US%22%3ERe%3A%20GOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754444%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you...%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754471%22%20slang%3D%22en-US%22%3ERe%3A%20GOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372017%22%20target%3D%22_blank%22%3E%40DaCrab%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754500%22%20slang%3D%22en-US%22%3ERe%3A%20GOLF%20GAME%20WORKBOOK%20AUTOMATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgree%20that%20vlook%20up%20should%20work!%3C%2FP%3E%3C%2FLINGO-BODY%3E
DaCrab
New Contributor

I am trying to create a workbook that can be used to figure who one the Golf Game. In Column B I have a list of names. In Column C I have the handicap associated with each name. I'm assuming the first step would be to build a Drop Down Box with all the names. When a name is selected I would think next to the name, in a separate cell, the handicap should appear. Any idea on how to make that happen? I've tried the V-LOOKUP Feature but can't get it to work.

 

6 Replies
You certainly need to attach your sample file.

@Twifoo 

Sir this project is crazy but I'm trying to do it. I'm "ok" with excel. My company runs on it and I wrote all the programs. We have been in business 30 years.

 

There is a "kid" that lives in a small rural community in Georgia. There are a bunch of guys that play Golf together three times a week. After the Golf game they would sit for an hour, maybe two, figuring up their bets. This "kid" I mentioned has never played golf but he created something for them. If you go to helpshae.com/index you will see what he created. We can't find this "kid" anymore and I'd like to duplicate what he's done but honestly, "I can't even figure out how to start."

 

The program he wrote adjust handicaps depending on who's in the game, it figures all the bets. Personally I think the "kid" is a genius and if I could find him I would hire him! LOL

 

What do you think?

@DaCrab 

Perhaps, this formula in B2 of the attached file will comply with your requirement: 

=IFNA(VLOOKUP(A2,
PlayerTable,
2,0),"Not Found")

Highlighted

Thank you...

@Twifoo 

@DaCrab 

You're welcome.

@Twifoo 

 

Agree that vlook up should work!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies