to Don: display last entry to cell automatically
 

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

to Don: display last entry to cell automatically
 

Hi,

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

Mike

"mike CBA" wrote:

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

to Don: display last entry to cell automatically
 

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)



mike CBA wrote:

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

--

Dave Peterson

to Don: display last entry to cell automatically
 

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mike CBA" wrote:

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

to Don: display last entry to cell automatically
 

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.



Shane Devenshire wrote:

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"mike CBA" wrote:

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

--

Dave Peterson

to Don: display last entry to cell automatically
 

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

--
Biff
Microsoft Excel MVP


"Dave Peterson" wrote in message
...
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.



Shane Devenshire wrote:

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"mike CBA" wrote:

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

--

Dave Peterson

to Don: display last entry to cell automatically
 

Me???

<vbg

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Dave Peterson" wrote in message
...
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.



Shane Devenshire wrote:

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"mike CBA" wrote:

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

--

Dave Peterson

--

Dave Peterson