Returning first "1"

Array Enter:

Formula:

=MATCH(2012+ROW($A1)&1,$A$1:$A$10&$B$1:$B$10,0)

and drag down.

An array entered formula is committed with Ctrl-Shift-Enter rather than just Enter

To remove errors:

Formula:

=IFERROR(MATCH(2012+ROW($A1)&1,$A$1:$A$10&$B$1:$B$10,0),"")

Welcome to the forum.

Trevor's assumed that the first column you showed (1 to 9) were just row numbers, with 2013/2014 in column A and the 0s/1s in column B.
I'd assumed different, that your 1-9 are in column A with the 2013/14 in B and 0/1 in C, in which case use this (wrapping Index round his formula):

Formula:

=INDEX($A$1:$C$10,MATCH(2012+ROW($A1)&1,$B$1:$B$10&$C$1:$C$10,0),1)

or, removing the errors,

Formula:

=IFERROR(INDEX($A$1:$C$10,MATCH(2012+ROW($A1)&1,$B$1:$B$10&$C$1:$C$10,0),1),"")

They're still array formulae, entered with Ctrl-Shift-Enter.

Hope that helps, if my assumption's correct - if not, please ignore me and go with Trevor's answer!

Guessing that should be

Formula:

=INDEX($A$1:$A$10,MATCH(2012+ROW($A1)&1,$B$1:$B$10&$C$1:$C$10,0),1)

Originally Posted by TMS

Guessing that should be...

Yes, that works too, since the returned value is in the first column - probably simpler to understand too .

Here is a regular one

Formula:

=IFERROR(INDEX(MATCH(1,--(B$1:B$9<>0)*(A$1:A$9=2012+ROWS(B$1:B1)),0),0),"")

v	A	B	C
1	2013	0	4
2	2013	0	8
3	2013	0
4	2013	1
5	2013	1
6	2013	0
7	2014	0
8	2014	1
9	2014	1

martis941 will the years always be increments of 1 ... ie is it possible the next year could be 2016 or 2017?