Forum Discussion
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
=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.
2 Replies
=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
