https://bugs.documentfoundation.org/show_bug.cgi?id=160893
m_a_riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #1 from m_a_riosv <[email protected]> --- Created attachment 193924 --> https://bugs.documentfoundation.org/attachment.cgi?id=193924&action=edit Sample file with XLOOKUP and MATCH It seems to have the same differences as MATCH(). Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f4ef5435df5560e6b6b061ce4053c71e2819bf51 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Excel $71,29 $86,92 =XLOOKUP("2024-01-15";A2:A4;B2:B4;"no invoice";0;2) 33,12 no invoice =XLOOKUP(DATE(2024;1;15);A2:A4;B2:B4;"no invoice";0;2) $71,29 $86,92 =XLOOKUP(T("2024-01-15");A2:A4;B2:B4;"no invoice";0;2) 33,12 no invoice =XLOOKUP(45306;A2:A4;B2:B4;"no invoice";0;2) $3,00 $2,00 =MATCH("2024-01-15";A2:A4;0) 1 #N/A =MATCH(DATE(2024;1;15);A2:A4;0) $3,00 $2,00 =MATCH(T("2024-01-15");A2:A4;0) 1 #N/A =MATCH(45306;A2:A4;0) -- You are receiving this mail because: You are the assignee for the bug.
