關鍵字 提取 (10777)

E2:H5=IF(ISERR(FIND(E$1,$C2)),,E$1)

無E1:H1=IF(ISERR(FIND(OFFSET($A$1,COLUMN(A1),),$C2)),,OFFSET($A$1,COLUMN(A1),))

另解{=INDEX(TRANSPOSE(IF(ISNUMBER(FIND($A$2:$A$5,$C2)),$A$2:$A$5,)),COLUMN(A$1))

區域數組{=IFERROR(TRANSPOSE(IF(FIND($A$2:$A$5,C2),$A$2:$A$5)),)