如果有以下情況..應該要點set? (用vlookup/sum)
sheet1:
(A) (B)
(1)Code Qty
(2)A111 2
(3)B222 2
(4)A111 3
(5)C333 1
(6)B222 2
(7)A111 3
(8)C333 1
咁sheet2我想要以數字
(A) (B)
(1)A111 (total Qty)
(2)B222 (total Qty
(3)C333 (total Qty)
如果我sheet2 column B用呢個=VLOOKUP(A1,Sheet1!A:B,2,FALSE) 佢就只會出左一個qty...但我係想要咁多個數加埋..
謝謝解答...!
(以上情況我一定要分開兩個sheet)