Issue 98535 - vlookup needs to have case sensitive option (or a new vlookups function that is case sensitive)
Summary: vlookup needs to have case sensitive option (or a new vlookups function that ...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-27 17:29 UTC by marspokane
Modified: 2013-12-18 08:54 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Spreadsheet showing incorrect answer to simple VlLOOKUP (12.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-01-27 17:30 UTC, marspokane 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description marspokane 2009-01-27 17:29:42 UTC 
This is an effort to appeal the function VLOOKUP (and HLOOKUP and LOOKUP for
that matter) for case sensitivity. This issue is related to Issue 98298
(http://www.openoffice.org/issues/show_bug.cgi?id=98298). I am attaching a
spreadsheet which illustrates how the function as it exists returns erroneous
information if attempting to match codes on rows being compared to derive
information from the other row.
Comment 1 marspokane 2009-01-27 17:30:52 UTC 
Created attachment 59713 [details]
Spreadsheet showing incorrect answer to simple VlLOOKUP
Comment 2 Edwin Sharp 2013-12-18 08:54:57 UTC 
According help:
"If SortOrder is set to FALSE or zero, an exact match must be found, otherwise the error Error: Value Not Available will be the result."

But this is not true - vlookup still fails when Sortorder=0.

AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian