Search code examples
arraysgoogle-sheetsmatchvlookuptextjoin

LOOKUP pickle in Google sheets (adding different payments from different clients and splitting them by month)

I have an issue with the use of LOOKUP formulas for this example:

enter image description here

I am trying to determine a way to add different payments from different clients by month

This is the worksheet and the information in blue is the desired result (which I am trying to automate).

Can someone shine a light as to which formulas to use, and how to accomplish that given I am separating the payments made from each client by month?

Solution

  • use:

    =INDEX(IFNA(VLOOKUP(B4:B6&C3:G3, {C10:C&TEXT(B10:B, "mmmm"), D10:D}, 2, )))

    enter image description here

    or if you want zeros:

    =INDEX(IFNA(VLOOKUP(B4:B6&C3:G3, {C10:C&TEXT(B10:B, "mmmm"), D10:D}, 2, ))*1)

    enter image description here