Forum Discussion
VLOOKUP or INDEX MATCH?
Hello, I am trying to create a formula that will A.) search a specific cell for the name of a month and B.) apply a corresponding divisor to cells within a set range. My question is, should ...
Hi John,
I'd recommend to use dates (let say first of each month) instead of texts for months and apply custom format as mmm/yyyy to them (I did that for May/2018 in attached).
When sum of days for previous 3 months could be
=SUM(INDEX($C$11:$C$25,MATCH($D$1,$B$11:$B$25,0)-3):INDEX($C$11:$C$25,MATCH($D$1,$B$11:$B$25,0)-1))
, see in J2 attached.