On Sat, 2006-05-06 at 13:03 +0400, Kirill S. Palagin wrote: > Hello. > > 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.
Help > Contents > Index > Search term > #NAME error message says 525 invalid names (instead of Err:525 cell contains #NAME?) An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, no macro, incorrect decimal divider, add-in not found. > Enclosing True or False in either single quotes does not change anything. > Using double quotes produces Err:502 as formula result. > Better check Help > Contents > Index > Search term > VLOOKUP function to see if your expression matches the example. I suspect that you have an error. > The only way to get it work is to use either 0 or 1. So 0 == FALSE and 1 == the first column in your array. Is this correct? > > What is wrong? Is there a bug in function or wrong description in Help > or I do something in a wrong way? > Without seeing your spreadsheet, it is *VERY* difficult to say. For myself, my crystal ball is all foggy today :-) Please put your spreadsheet on your website so we can look at it or open an issue and attach the faulty sheet to it. Lastly let us know the issue number. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
