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

bru1987 0
Viewed 23

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 minimum example 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?

textjoin vlookup match google-sheets arrays
1 Answers

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

player00
Related