Forum Discussion
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 say...
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.
I 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.
N4 have this formula =COUNTIF(U6:U21,"I")
When no teams have no P in column B OR G. I want 0 in N4 than N5 should be 0%. just like got right
Thanks you.
sf49ers19238597 Maybe make column U (correct/incorrect) blank when either V or W is blank. see Pick Them Week 1 in attached
