SOLVED

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

Iron Contributor

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

@sf49ers19238597 

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

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

1 best response

Accepted Solutions
best response confirmed by sf49ers19238597 (Iron Contributor)
Solution

@sf49ers19238597 

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

View solution in original post