Forum Discussion
Excel Formulas (Indirect(index(match)))
Hello, I have two worksheets, TestFund (First below) and "Aggregate" second image below. I am trying to transpose the info from the TestFund worksheet in the "Aggregate" worksheet and i am curre...
I'm not sure if this is just a learning thing or maybe just an example as what I see could easily done with 1 formula. The whole range on aggregate A16:E20 could be this formula in A16:
=TRANSPOSE(TestFund!A6:E10)
I really don't see the need for SUMIF but lets assume a very generic case and using just index and match:
=index($B$7:$E$10, match($A17,$A$7:$A$10,0), match(B$16, $B$6:$E$6, 0) )
=TRANSPOSE(TestFund!A6:E10)
I really don't see the need for SUMIF but lets assume a very generic case and using just index and match:
=index($B$7:$E$10, match($A17,$A$7:$A$10,0), match(B$16, $B$6:$E$6, 0) )