|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
例如:
编号:IF(ROW(A1)<=COUNTIF(INDIRECT(TEXT($B$4,"0000")&"!$J:$J"),$D$4),ROW(A1),"")
商品名称:IFERROR(INDEX(INDIRECT(TEXT($B$4,"0000")&"!$D$8:$D$1000"),MATCH($D$4&B8,INDIRECT(TEXT($B$4,"0000")&"!$J$8:$J$10000")&INDIRECT(TEXT($B$4,"0000")&"!$B$8:$B$1000"),0)),"")
数量:IFERROR(INDEX(INDIRECT(TEXT($B$4,"0000")&"!$E$8:$E$1000"),MATCH($D$4&B8,INDIRECT(TEXT($B$4,"0000")&"!$J$8:$J$10000")&INDIRECT(TEXT($B$4,"0000")&"!$B$8:$B$1000"),0)),"")
公式都写在附件中,可以直接用 |
评分
-
1
查看全部评分
-
|