1: D2=VLOOKUP(C2,F:G,2,FALSE) 2 D17=COUNTIFS(F17:G22,116) 3 D25=IF(F25=111,TRUE) 4:拼接 E33=A33&B33&C33&CHAR(10)&"99999"&CHAR(10)&D33 5:查询所有图表:CTRL + G