to Don: display last entry to cell automatically

[mike CBA]

the formula =lookup(999999,b:b) resulted in #NAME?

 

[Mike H]

Hi,

It shouldn't do if you copy it exactly as it appears in your post.

Mike

 

[Dave Peterson]

Are you using an English version of excel? (Maybe the function is named
something else in your language.) If you don't use English, what language do
you use?

Are you in R1C1 reference style?
try:
=lookup(999999,C2)

 

[Shane Devenshire]

Hi,

Also, in some language settings "," is replaced by "."

 

[Dave Peterson]

I think it's more common for the list separator to be a semicolon ( then a
dot.

Although, there are differences between decimal and thousands separators, too.

 

[T. Valko]

The list separator wouldn't cause a #NAME? error. You'd get the general
formula error: The formula you typed contains an error.

 

[Dave Peterson]

Me???

<vbg>

The list separator wouldn't cause a #NAME? error. You'd get the general
formula error: The formula you typed contains an error.