https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #11 from Regina Henschel <[email protected]> --- Created attachment 194707 --> https://bugs.documentfoundation.org/attachment.cgi?id=194707&action=edit Examine text as number in MATCH, VLOOKUP, LOOKUP, XMATCH and XLOOKUP Text, which could be interpreted as number is affected too. The error occurs in MATCH with Match_mode 0, i.e. exact search, sorting does not matter here XMATCH with Match_mode 0 and Search_mode 1, i.e exact search on maybe unsorted data. VLOOKUP on unsorted data XLOOKUP with Match_mode 0, sorting does not matter here The error does not occur in MATCH with Match_mode 1, i.e. approximate search on sorted data. XMATCH with Match:mode 1, i.e. approximate search, sorting does not matter here. VLOOKUP on sorted data XLOOKUP with Match_mode 1, sorting does not matter here. LOOKUP The error is only if the Lookup_value is a text and the values in the Lookup_array are numbers. The other way round, Lookup_value is number and the values in the Lookup_array are text, is always correct. -- You are receiving this mail because: You are the assignee for the bug.
