I need some spreadsheet help.
1 ) I set up an entry form with all the players for the World Juniors.
2) participants use this entry form to select their teams by using the drop down options on the entry form.
3) In a separate spreadsheet, I copied all the names from the entry form spreadsheet into the standings spreadsheet.
4) When I receive entries and enter them into the standings spreadsheet, the vlookup does not recognize the names from the entry form....
Please help!!!!
-------------------------------------------------------------------------------------------------------
Be easier to be able to see the spreadsheet... It could be as something simple as an extra space in the name.
Okay think I found the spreadsheet... now to see what you are asking.
Your standings is using HLookUp though not VLookup.
Interested in being a Dobber Hockey champion?
Join Our Tiered League Now!
Climb your way to the top of a three tiered Roto league.
Check out the link below for more info or PM me!
https://forums.dobbersports.com/show...League-2023-24
On Entries tab line 30 the ranks are still N/A for some of them. If the formula only looks at the first 3 you have point totals for you will get a rank and the rest should work out.
Interested in being a Dobber Hockey champion?
Join Our Tiered League Now!
Climb your way to the top of a three tiered Roto league.
Check out the link below for more info or PM me!
https://forums.dobbersports.com/show...League-2023-24
I believe PH has fixed this now.
12 team H2H Most Cats Wins; Keep 6/winner keeps 7; G A PPP +/- SHP SOG HIT BLK PIM // W SV GAA SV% SHO
3 C, 3 LW, 3 RW, 6D, 2G, 5 bench
C - McDavid, Crosby, Tavares, Hertl
LW - DeBrincat, Boldy, Lafreniere
RW - Meier, Miller, Boeser, Nichushkin
D - Dobson, Karlsson
G - Jarry, Luukkonen
If you haven't gotten it fixed yet, let me know.
Want a Signature? Go to Settings, and you'll find Edit Signature down the list on the left.