2018-08 | 1 Aug 18 | 31 Aug 18 | ||
2018-09 | 1 Sep 18 | 30 Sep 18 | ||
2018-10 | 1 Oct 18 | 31 Oct 18 | ||
<tbody>
</tbody>
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)