M
mike CBA
the formula =lookup(999999,b:b) resulted in #NAME?
M
Mike H
Hi,
It shouldn't do if you copy it exactly as it appears in your post.
Mike
It shouldn't do if you copy it exactly as it appears in your post.
Mike
D
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)
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)
S
Shane Devenshire
Hi,
Also, in some language settings "," is replaced by "."
Also, in some language settings "," is replaced by "."
D
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.
then adot.
Although, there are differences between decimal and thousands separators, too.
T
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.
formula error: The formula you typed contains an error.
D
Dave Peterson
Me???
<vbg>
<vbg>
T. Valko said: