Forum Discussion
Requesting assistance with dynamic list with 2 way lookup
I am trying to make a summary table from a larger dataset. I've attached a fictitious sample of data that I've used to conceptualize my desired output. I am using index small and match functions in...
The formula in L32:L36 has to be amended.
=AGGREGATE(15,6,1/(1/MMULT(ROW($A$7:$A$16)*($C$18:$R$18)*($C$7:$R$16=TRUE)*($A$7:$A$16=$D$27)*($I$7:$I$16=H$26)*($J$7:$J$16=I$26);ROW($1:$16)^0)),K32)-6
Thanks again for being so responsive.
This new formula does get the desired output; but when the month of interest changes I would want to reference columns q and r, instead of the static reference to i and j. How can I achieve that?