- =SUBSTITUTE(CONCATENATE(IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,9,)),"/"&'Sheet 1'!$I$1,),IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,10,)),"/"&'Sheet 1'!$J$1,),IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,11,)),"/"&'Sheet 1'!$K$1,),IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,12,)),"/"&'Sheet 1'!$L$1,),IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,13,)),"/"&'Sheet 1'!$M$1,),IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,14,)),"/"&'Sheet 1'!$N$1,),,IF(ISNUMBER(VLOOKUP(A2,'Sheet 1'!A:P,15,)),"/"&'Sheet 1'!$O$1,),IF(VLOOKUP(A2,'Sheet 1'!A:P,16,)<>"","/"&VLOOKUP(A2,'Sheet 1'!A:P,16,),)),"/",,1)
复制代码
|