{:30:}我怎么会写出这样的公式~~哎~ 三键下拉 最多10个单号 如果还需要更多 请在公式后边添加第二个公式 并且最后的10改成11,类推- =INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$1)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$2)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$3)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$4)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$5)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$6)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$7)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$8)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$9)))&INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$10)))
复制代码- &INDEX(出库单!B:B,SMALL(IF(A3&B3=出库单!C$2:C$26&出库单!A$2:A$26,ROW($2:$26),4^8),ROW(A$10)))
复制代码 忘记个事情了 你的数据源单据编号有重复。。
|