Date and Data???

[coccio]

I’m having a problem

From A1 to IV1 dates are entered each day
From A2 to IV2 numeric values are entered each day

Each day a new date and a new numeric value is entered in those cells

What I want to do is as a new more current date and data is entered I want a formula to recognize that and plug in the new data in a fixed cell such as A10.

 

[IML]

you could use

=INDEX(1:2,2,MATCH(MAX(1:1),1:1,0))