nfl schedules need help with road team score & Home Team scores

[sf49ers19238597]

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

[#2]

@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.

[#3]

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.

[#4]

@sf49ers19238597 

Try

=IFERROR(VLOOKUP(C6,'INPUT SCORES'!$A$5:$S$36,2,0),0)

[#5]

@Hans Vogelaar 

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.

[#6]

@sf49ers19238597 

I'm sorry, you've lost me completely.

[#7]

@sf49ers19238597   Maybe make column U (correct/incorrect) blank when either V or W is blank.  see Pick Them Week 1 in attached