Hello,
I was hoping someone might be kind enough to help me with a vlookup question.
I'm trying to sum the results of a vlookup, where the lookup criteria are: (1) visible values in a filtered list; and (2) a static value.
So based on the screenshot below, if I filter Table A for George and John, in Row 2 I should get 9 for March, and 11 for April.
So 'George' and 'John' are the visible values in the filtered list. And 'March' and 'April' are static values, and which form a second criterion.
Could someone please help me? I'd be so grateful.
I've looked up combining index, match, and subtotal with vlookups, but am at a complete loss...
Thanks!
I was hoping someone might be kind enough to help me with a vlookup question.
I'm trying to sum the results of a vlookup, where the lookup criteria are: (1) visible values in a filtered list; and (2) a static value.
So based on the screenshot below, if I filter Table A for George and John, in Row 2 I should get 9 for March, and 11 for April.
So 'George' and 'John' are the visible values in the filtered list. And 'March' and 'April' are static values, and which form a second criterion.
Could someone please help me? I'd be so grateful.
I've looked up combining index, match, and subtotal with vlookups, but am at a complete loss...
Thanks!