用上期和值做433断组
=CONCATENATE(4," ",LOOKUP(--M3,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27},{"0568-279","1356-497","1479-263","0236-491","0239-164","3489-276","0456-197","2456-387","2358-709","0568-139","1378-269","0689-273","3458-902","1269-478","1378-269","1269-478","1378-269","2456-387","0239-164","1356-804","1479-263","4679-128","1359-278","1359-278","1456-907","0789-164","0679-382"}),"-",IF(COUNT(FIND(0,LOOKUP(--M3,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27},{"0568-279","1356-497","1479-263","0236-491","0239-164","3489-276","0456-197","2456-387","2358-709","0568-139","1378-269","0689-273","3458-902","1269-478","1378-269","1269-478","1378-269","2456-387","0239-164","1356-804","1479-263","4679-128","1359-278","1359-278","1456-907","0789-164","0679-382"}))),"",0)&SUBSTITUTE(SUM(IF(ISNUMBER(FIND(ROW($1:$9),LOOKUP(--M3,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27},{"0568-279","1356-497","1479-263","0236-491","0239-164","3489-276","0456-197","2456-387","2358-709","0568-139","1378-269","0689-273","3458-902","1269-478","1378-269","1269-478","1378-269","2456-387","0239-164","1356-804","1479-263","4679-128","1359-278","1359-278","1456-907","0789-164","0679-382"}))),FALSE,ROW($1:$9))*10^(9-ROW($1:$9))),"0",),)
用4码分别配3码组成2码
