How to use the formula of Vlook in excel?

TOP URGENT -For example: there are 2 sheet one is "A" & another one is "B". A sheet included column A-A/C code, column B-name, column C-amount in HKD. row 1 to 10 is A co. row 11 to 25 is B co. row 26-33 is c co. Actually B sheet is a summary, column A-A/C code, column B-name, for column C s/b the total amount of "A" sheet's column C. How can I use the formula of Vlook in excel? you may answer the question in Chinese.

1 個解答

評分
  • 1 十年前
    最愛解答

    Vlookup 是不會加數, 你的情況, 如只有一個準則, 應用Sumif

    但你的題目是有兩個準則(a/c code & name), 便要用sumproduct

    在 SheetB 的C2 輸入公式:

    =Sumproduct((SheetA!$A$2:$A$1000=A2)*(SheetA!$B$2:$B$1000=B2),SheetA!$C$2:$C$1000)

    然後將公式下拉

還有問題嗎?立即提問即可得到解答。