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
|