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