SOLVED

Iron Contributor

# I have two worksheet I need help somehow put bye on input score from Input Scores automatically

I have two worksheet. I need help somehow put bye on input score from Bye Week worksheet automatically from bye week worksheet. have lookup team names on both worksheet. mayb with a if statement

Thanks You

2 Replies
best response confirmed by sf49ers19238597 (Iron Contributor)
Solution

# Re: I have two worksheet I need help somehow put bye on input score from Input Scores automatically

=IFERROR(INDEX('INPUT SCORES'!\$A\$2:\$A\$33,SMALL(IF('INPUT SCORES'!\$H\$2:\$H\$33="Bye",ROW('INPUT SCORES'!\$A\$1:\$A\$32)),ROW('INPUT SCORES'!\$A1))),"")

You can try this formula for week 7. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. For the other weeks the column from INPUT SCORES has to be adapted. Some more formulas are entered in your file.

# Re: I have two worksheet I need help somehow put bye on input score from Input Scores automatically

I meant say put on input score worksheet from Bye Week worksheet. The scores  I use a userform