Forum Discussion

Iron Contributor

Apr 17, 2024

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

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

Iron Contributor

Apr 22, 2024

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

Bronze Contributor

Apr 22, 2024

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))),"")