My current formula already returns a blank in the row if a names doesn't show up.
Column A formulas {=IFERROR(INDEX(names, SMALL(IF("Y"=Alphabetical!$I$2:$I$185, ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(A31))),"")}
Column B formulas {=IFERROR(INDEX(names, SMALL(IF("YC"=Alphabetical!$I$2:$I$185, ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(E7))),"")}
|