Hi, i removed "+1" from the code because it add a day to my date (i have
01.09.2009, and the code display 02.09.2009).
The code it's working but it's not displaying next cell.
If "I2" has numbers, your code display content from "I1"
I need your code to display content of next cell (J1)
Can this be done?
Thanks!

"Teethless mama" wrote:

=IF(COUNT(A2:L2),LOOKUP(2,1/(A2:L2<""),A1:L1)+1,A1)


"puiuluipui" wrote:

Hi, i have dates in range A1:L1.
In range A2:L2 i will have numbers.
If A2:L2 is empty, then the code to display content of A1.
If A2 has some numbers, then the code to display content of B1.
If B2 has some numbers, then the code to display content of C1.
If C2 has some numbers, then the code to display content of D1.
.......and so on...
Can this be done?
Thanks!