<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Change name (description) of 4th argument to VLOOKUP and HLOOKUP to "Sorted range lookup" in help and in function wizard (see comment 7, comment 9)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121090#c15">Comment # 15</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Change name (description) of 4th argument to VLOOKUP and HLOOKUP to "Sorted range lookup" in help and in function wizard (see comment 7, comment 9)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121090">bug 121090</a> from <a class="email" href="mailto:jean-francois.nifenecker@laposte.net" title="Jean-Francois Nifenecker <jean-francois.nifenecker@laposte.net>"> Jean-Francois Nifenecker</a> <pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=121090#c14">comment #14</a>) > Well, if needed, the first sentence of the 4th param > > > Sorted is an optional parameter that indicates whether the first column in > > the array is sorted in ascending order. > > could be changed to something like: > > > Sorted(RangeLookup) is an optional parameter that indicates whether the first column in the array represents a range list sorted in ascending order. > > This actually addresses the valid concern from <a href="show_bug.cgi?id=121090#c12">comment 12</a>. In fact, IMO, the point is not exactly the description of this argument but the description of its consequences on the function result when VLOOKUP() can't match an exact value. If set to 1/True No exact match -> the result is an approximative match. The user has no clue about that and could think the result is the actual match (most do!). If set to 0/False No exact match -> the result is a #N/A error. Now, the user actually *knows* the looked up value was not retrieved and can take appropriate action. Not sure if theses consequences are always made clear. During trainings I always have to insist on this point because of the consequences of not selecting the right option. My 2 euro-cents.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>