Attached is a test spreadsheet that shows the issue.
XMATCH fails when doing a numeric lookup when the lookup value is an exact match when the XMATCH match_mode is either ‘Exact match or next largest item’ or ‘Exact mat…... val worksheet = workbook.worksheets["Sheet1"] listOf(...fails, should return 6", worksheet.calculateFormula("=XMATCH(34500...