https://issues.apache.org/ooo/show_bug.cgi?id=125804
Andreas Säger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Andreas Säger <[email protected]> --- LOOKUP in all spreadsheets of the past 3 decades works differently than most of todays users expect. LOOKUP does NOT lookup single items as shown by the following formula in your document: =LOOKUP("xyz text"; Lookups.$E$1:$E$3 ; Lookups.$F$1:$F$3) The formula will return a value for the non-existing search value regardless of your list being sorted or not. Since most of todays users want to mis-use a spreadsheet as a database, =VLOOKUP("xyz text"; Lookups.$E$1:$F$3 ; 2 ; 0) is the "right" function call and does not require a specific sort order. The zero is the important parameter here. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
