Scoring Spreadsheet IF Statement

Hoping someone can help so I'll try to explain it well enough.
I'm making a scoring spreadsheet with multiple entrants (Brian, Sara, Sally, Dave etc)
Spreadsheet will have multiple stages (10 total) where a raw score is added to penalty score for a final stage score, all the stage scores talley to the far left next to the entrants names under "Total Score" (lowest score is the winner).
^^^easy enough

If an entrant does something not allowed in a stage, the Final Stage score will be labeled "DQ" (Disqualified) and the Raw Score + Penalty Time formula will be overridden with a simple text: "DQ"
I have a column next to the "Total Score" labeled "DQ" where the formula I am looking for would search all the Final Scores by Stage for the "DQ" and label that cell "DQ" for quick reference. I also plan on Conditional Formating that column that is a cell contains "DQ" it will fill red with red letters (easy enough)

I have gotten as far as:

=IF(ISNUMBER(SEARCH("DQ",[@[Final Score Stage 1]])),"DQ","")
Final Score Stage 1= cell H11
"DQ" shows up in the DQ column perfectly

then tried, by dragging the whole row:

=IF(ISNUMBER(SEARCH("DQ",Table1[@[Raw Score Stage 1]:[Final Score Stage 10]])),"DQ","")

This caused the column DQ to lose the "DQ" even though I still had "DQ" in cell H11 (aka: Final Score Stage 1)

What I am hoping for is if a score keeper puts "DQ" in any one Final Score Stage # then it will show in the Match DQ column as well.

Thanks anybody...

Hi,

Welcome to the Forum.

Can you please post the template you are trying to build using "Go Advanced" option below?