| Summary: | EDITING: Incorrect LOOKUP Function | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | jakenveina |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | gerard.fargeot, jokusoftware |
| Priority: | medium | ||
| Version: | 3.3.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | The attachment is the specific spreadsheet with the specific set of data for which LOOKUP is malfunctioning | ||
Please read the help : http://help.libreoffice.org/Calc/Spreadsheet_Functions#LOOKUP "Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results." I closed this bug. |
Created attachment 53331 [details] The attachment is the specific spreadsheet with the specific set of data for which LOOKUP is malfunctioning Problem description: In the attached spreadsheet, the LOOKUP Functions in Columns B and C are failing to lookup correctly. The first errored result occurs in Row 9. The value in A9 should be matched to the value in G9, causing the values in H9 and I9 to be pushed to B9 and C9, respectively. Instead the LOOKUP function is matching A9 to G37, and pulling from H37 and I37. This makes no sense as the values in A9 and G37 clearly do not match. In the spreadsheet, I have even copied the column G directly to column A, to ensure that the values are exactly the same, regardless of formatting, and the same result occurs. I have also tried formatting columns A and G as both numbers, and as plain text, and re-entering all the values accordingly. Whether the columns are numbers or text, the exact same result occurs. I have additionally checked that the function "=(A9=A37)" returns FALSE for all of these circumstances. Browser: Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1