Forum Discussion
Solved
Index match - formula moving columns and rows
Hi guys, First time poster, long time excel user! Briefly, i am trying to automate a data import to show the total sales per sales centre per month using a combination of SUM IF and INDEX-MAT...
You may try something like this...
=SUMIF($C$5:$C$18,$A24,INDEX($D$5:$O$18,,MATCH(B$23,$D$3:$O$3,0)))
You may try something like this...
=SUMIF($C$5:$C$18,$A24,INDEX($D$5:$O$18,,MATCH(B$23,$D$3:$O$3,0)))
Excellent, that worked!
May i ask what i was doing wrong and what the double comma between index and match does? I have never seen that before?
Thank you once again!
Please pay attention to the array you are passing inside the Index function, the first argument. I have used a two-dimensional array which is the key of the formula.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.