Created attachment 193773 [details] Test for XMATCH and empty cell Open attached document. It has cells with expected value (what Excel calculates) and actual value (what LibreOffice calculates) and a cell, which shows the formula as text. Press Ctrl+Shift+F9 to force recalculation. The similar problem for XLOOKUP is in 160711 and Balázs has fixed that already.
Reproducible Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7c2ed9919d6d9d286d9062b91577d6bb2b7de8aa CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded On the first case, need to have at least one larger than searched value. On the second case, having an empty in double quotes (=XMATCH("";B2:B15)) as the first parameter also doesn't work.