譚惟心,選擇性貼上,轉置Transpose,VLOOKUP,HLOOKUP,ROW

 

=VLOOKUP($A2,損益表,14,)

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