Issue filed. See http://www.openoffice.org/issues/show_bug.cgi?id=65137
> -----Original Message----- > From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 06, 2006 11:09 PM > To: [email protected] > Cc: Kirill S. Palagin > Subject: Re: [users] Calc - Vlookup 4th parameter (Sort > order) is notaccepting "True" or "false" > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
