Oct 16 2020 08:47 AM
I'm trying to retrieve the amount in January if name 'John' is also matching. =if(match(B1,A7:C11,vlookup(A2,B7:C11,2,false))
Example:
I'm trying to retrieve data using match and vlookup but it's not working. The destination file look like:
Can anyone help? I'd be very grateful. Thanks.
Oct 16 2020 09:04 AM
In B2:
=SUMIFS(Sheet1!$C$2:$C$1000, Sheet1!$A$2:$A$1000, B$1, Sheet1!$B$2:$B$1000, $A2)
Fill to the right then down (or vice versa)