Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Aug 03, 2023

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

  • sf49ers19238597 

    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.

    • sf49ers19238597's avatar
      sf49ers19238597
      Iron Contributor
      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.

Resources