Forum Discussion
sf49ers19238597
Aug 03, 2023Iron Contributor
nfl schedules need help with road team score & Home Team scores
I will show you pick them week 1.I have 1 pick them worksheet I need help with formulas put in scores from input scores worksheet. It is giving me a #N/A error.
I also need help with got wrong saying if possible I want say 0 when no game have been pick and no score on nfl schedule week 2. on
I need help with file called nfl schedules. This is one my friend file.
You can look nfl schedule file is mine will give you what he want on his file.
just get scores working only
Thanks You
The formula in D6 should be
=VLOOKUP(C6,'INPUT SCORES'!$A$5:$S$36,2,0)
For week 2:
=VLOOKUP(C6,'INPUT SCORES'!$A$5:$S$36,3,0)
etc.
- sf49ers19238597Iron ContributorI also need help with got wrong saying in cell N4 if possible I want say 0 when no game have been pick and no score on pick them worksheet.