How find first blank cell?

[Migre]

I have a little problem.Try explane it.
I work with the range A2:L2. At the start, all cells are blank.
Then I enter value to cell A2 whis value must be shown in cell M2,
If, after that, I enter value to cell B2 it must be shown in cell M2. And so on.
How I can do this without macros?
Thanx.

 

[fairwinds]

Welcome to the board!

If you are talking about numbers, put this in M2:

=LOOKUP(9.99999999999999E+307,A2:L2)

 

[KenWright]

Are your values numbers - if so then in M2

=LOOKUP(9.99999999999999E+307,A2:L2)

or

=OFFSET($A$2,,COUNTA(A2:L2)-1)

 

[Migre]

fairwinds, KenWright, thank you vary much. The values are numbers. I read help for this functions, but....