https://bugs.documentfoundation.org/show_bug.cgi?id=167134
--- Comment #4 from nobu <[email protected]> --- Wiki Page https://wiki.documentfoundation.org/Documentation/Calc_Functions/LOOKUP The content of the wiki is complex, but it states that inline arrays receive special treatment. If Wiki is correct, the current behavior of the LOOKUP function appears to be correct. The result and formula are as follows: Helium =LOOKUP(2; {1;2;3}; {"Hydrogen";"Helium";"Lithium"}) Helium =LOOKUP(2; {1,2,3}; {"Hydrogen","Helium","Lithium"}) #N/A =LOOKUP(2; {1,2,3}; {"Hydrogen";"Helium";"Lithium"}) #N/A =LOOKUP(2; {1;2;3}; {"Hydrogen","Helium","Lithium"}) But in Google spreadsheet, all of the above formulas will be "Helium". And I can't find any mention of inline arrays getting special treatment in the help. I don't know about MS Excel. -- You are receiving this mail because: You are the assignee for the bug.
