Hi,

Your formula wouldn't find anything becasue there was a syntax error, try this

=INDEX(B5:B410,MATCH(1,C5:C410),0)

or another

=LOOKUP(2,1/(C5:C410=1),B5:B410)


Mike

"PJ Murph" wrote:

I'm trying to find the date (which is in column B) of the LAST occurrence of
a number (in this instance number 1) in column C. This formula only locates
the first occurrence; =INDEX(B5:B410),MATCH(1,C5:C410),0)).