optimized: spill
more 2 (does not use TEXTAFTER)
=LET(
matched, XLOOKUP($J3:$J109, allquestions[number], allquestions[more2], "number not found", 0),
cleaned, IF(LEFT(matched, 20) = "is incorrect because",
MID(matched, 22, LEN(matched) - 21),
matched),
IF(cleaned = $K3:$K109, "dupe", cleaned)
)
more 3 (does not use TEXTAFTER)
=LET(
matched, XLOOKUP($J3:$J109, allquestions[number], allquestions[more3], "number not found", 0),
cleaned, IF(LEFT(matched, 20) = "is incorrect because",
MID(matched, 22, LEN(matched) - 21),
matched),
IF((cleaned = $K3:$K109) + (cleaned = $L3:$L109), "dupe", cleaned)
)