I need help with fixing formulas for scores without BYE in the score area

[sf49ers19238597]

I need help with fixing formulas for scores without BYE in the score area

Thanks You

[#2]

@sf49ers19238597 

Hi, try repairing the formula in D15:

=LET(in,TRIM(CHOOSECOLS('Yearly Schedule'!A1:F273,1,4,6)),tl,FILTER(in,MMULT(--(in=$A$2),{0;1;1}),""),tw,TAKE(tl,,1),tt,SUBSTITUTE(INDEX(tl,,2)&INDEX(tl,,3),$A$2,""),XLOOKUP(SEQUENCE(18),--tw,tt,"BYE "))

"BYE " must be "BYE"

=LET(in,TRIM(CHOOSECOLS('Yearly Schedule'!A1:F273,1,4,6)),tl,FILTER(in,MMULT(--(in=$A$2),{0;1;1}),""),tw,TAKE(tl,,1),tt,SUBSTITUTE(INDEX(tl,,2)&INDEX(tl,,3),$A$2,""),XLOOKUP(SEQUENCE(18),--tw,tt,"BYE"))

[#3]

Wrong column I need help with. I need help with column C

[#4]

@sf49ers19238597 

Enter the formula in C15 and then copy it down.

=IFERROR(IF(ISNUMBER(FIND("BYE",D15)),"",IF(VLOOKUP($A$2,INPUTSCORES,A15+1,FALSE)="","",VLOOKUP($A$2,INPUTSCORES,A15+1,FALSE))),"")