傳回數值 依規定 (12966)

D3:I5=CHOOSE($C3,IF(COLUMN(A1)=1,$D$1,""),IF(COLUMN(A1)=2,$E$1,""),IF(COLUMN(A1)>2,$F$1,""))

另解=IF(COLUMN(A1)>2,IF($C3=3,$F$1,""),IF(COLUMN(A1)=$C3,LOOKUP($C3,{1,2,3},$D$1:$F$1),""))



留言