https://bugs.documentfoundation.org/show_bug.cgi?id=54497
--- Comment #6 from Luke <[email protected]> --- Created attachment 114390 --> https://bugs.documentfoundation.org/attachment.cgi?id=114390&action=edit Sample document showing how to use VLOOKUP correctly QA Team, Before accepting a bug like this we need to be very careful to review the definition of the function. This ensures that we will not break interoperability with ourselves or MS Office. VLOOKUP Function =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) where: Argument Definition of argument --------------------------------------------------------------------- lookup_value The value to be found in the first column of the array. table_array The table of information in which data is looked up. col_index The column number in the table_array for which the matching value should be returned. range_lookup It is a logical value that specifies whether you want to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned; in other words, if an exact match is not found, the next largest value that is less than the lookup_value is returned. If FALSE, VLOOKUP finds an exact match. If an exact match is not found, the #N/A error value is returned. Therefore, to perform a case-sensitive VLOOKUP, you need to combine the VLOOKUP functions with a helper functions. You can find multiple tutorial on the Internet, such as: https://www.google.com/search?q=VLOOKUP+is+not+case+sensitive&ie=utf-8&oe=utf-8 In my attached example, VLOOKUP is performing a case-sensitive Lookup for "joe" -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
