What is the best formula?

[autotim]

Rows 2-100 in Cols A to G contain numbers from 0-10. Row 1 in Cols A to G contains dates. I want a formula that looks along the row to see when any number last occured and then reports the date on which that number occured. Thanks in advance.

 

[mikerickson]

Assuming that today is in A1 and six days ago is in G1:

=MATCH(A2:G2,1,0) will return the most recent entry of 1 in row 2

 

[autotim]

01.01.07 08.01.07 13.01.07 27.01.07 03.02.07 Result
1 2 2 - - 13.0107

I want the formula to look in row 1 and determine that 13.01.07 was the last time a cell was filled and display that date in as the result.