Kirill S. Palagin wrote:
When constructing formula with vlookup I need to specify 4 parameter
(Sort order).
Help clearly says that it could be True or False, yet when I put either
as 4th parameter I get "#NAME?" error.
Enclosing True or False in either single quotes does not chang anything.
Using double quotes produces Err:502 as formula result.
The only way to get it work is to use either 0 or 1.
What is wrong? Is there a bug in function or wrong description in Help
or I do something in a wrong way?
The TRUE and FALSE constants for formulas have to be entered in the
language of the configured locale setting (default is your system
locale). But they are then converted to 1 or 0 anyway.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
