Okay, the title probably sounds really confusing, but what I am trying to accomplish, is a formula, that would go through values (dates) on a row. When a date with same year and month is found, it would return the value two columns right. Note, that there might be several matching cells with same month/year, so it shouldn't stop on the first match found.
So far, I've tried something like this:
INDEX(A2:J2;1;MATCH(DATE(YEAR(A1);MONTH(A1);1)+2;A2:J2;0))
Note, that I am using Finnish excel, so ';' might have to be replaced with ','..
\1
Please help!![]()
Bookmarks