=INDEX(Sheet1!A:A,SMALL(IF((Sheet1!$D$3:$D$3000="赊销")+(Sheet1!$D$3:$D$3000="收回欠款"),ROW($3:$3000),4^8),ROW(A1)))&""按【组合键】确认后右拖、下拉填充。
