|2018-08||1 Aug 18||31 Aug 18|
|2018-09||1 Sep 18||30 Sep 18|
|2018-10||1 Oct 18||31 Oct 18|
Please see table above.
If I have a date like 9/15/18, I want it to run a search against this table, then return the corresponding result in col A, ie 2018-09. At the moment it's a looong list of if statements, which I'll fix. I would've expected an index match to fix it but when I do that, for some reason I get 2018-08 as the answer, instead of 2018-09. I've fixed that by entering
But why do I have to type in the +1 ?INDEX(A1:A3,MATCH(lookupfigure,C1:C3)+1)