胡家菘,選擇性貼上, 轉置Transpose, VLOOKUP, HLOOKUP, Column, Row

EXCEL函數： =VLOOKUP($A2,損益表,14,FALSE)

=VLOOKUP($A13,$A$2:$F$8,F$12,) 

=COLUMN(E1) =ROW(A1) 

=TRANSPOSE(F2:F5) =HLOOKUP(B$28,橫變直,$A29,FALSE)

劉任昌095教學影片

劉任昌096教學影片