Iron 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

6 Replies

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

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.

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

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.

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

Try

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

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

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.

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

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

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

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