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