=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Square brackets are documentation markers for optional parameters, not characters to type in a formula. Formula names and comma-separated arguments here follow ONLYOFFICE’s official function-entry guide. Locale settings can affect punctuation and displayed formats.

Create a new sheet with these small source records:

If a cell is marked leave empty, leave it truly empty rather than entering the words in the table. Put the formula in a free cell away from the source data.

=XLOOKUP(1003,A2:A5,B2:B5,"Not found")

Expected result: Clips. ID 1003 matches row 4, where the Item field is Clips. This is an arithmetic/logical prediction on the supplied sample, not a claim of native ONLYOFFICE testing.

=XLOOKUP(9999,A2:A5,B2:B5,"Not found")

Expected result: Not found. The ID does not exist and the optional fallback is used. Comparing these two results helps identify incorrect ranges and mismatched conditions.

Search item names with a wildcard and return the stock column.

=XLOOKUP("Pa*",B2:B5,C2:C5,"Missing",2)

Expected result: 12. Wildcard match mode 2 finds Pads and returns its quantity 12. Change just the source value described above to reproduce the variation.

Binary modes 2 and -2 require an appropriately sorted search range, or the official guide warns results may be wrong. Matching arrays must align, and XLOOKUP is identified as an array formula.

Unrecognized formula names, missing arguments, incorrect parentheses and incompatible separators may cause an error. When an output is surprising, test the small example first, check whether input values are genuine numbers, then inspect the formula’s range endpoints. Do not guess a specific error label when it has not been produced by a native test.

Start with an exact known ID. Verify fallback handling, wildcard match_mode=2, and array size; multi-cell outputs require the correct insertion workflow. If formulas are displayed as text, ensure the destination cell is treated as a formula and starts with an equals sign. If copying a formula, decide which references should remain fixed and apply $ anchors as needed.

Docs 9.1.0 reports performance optimization and 9.3.0 reports dynamic arrays; neither is a documented introduction date.

The official array formula guide lists XLOOKUP. It documents selecting an output range and Ctrl+Shift+Enter, while ONLYOFFICE Docs 9.3.0 added dynamic arrays. Test the particular Desktop, Cloud or Mobile build rather than assuming identical spill behaviour.

The official changelog was reviewed on 2026-10-11 UTC. No unsupported introduction date or minimum edition is invented.

XLOOKUP is supported in recent Excel versions but not all legacy editions. For older workbooks, VLOOKUP or INDEX/MATCH may be required. Microsoft also provides a version-aware function catalogue. Consult the eight-software comparison for navigation, but verify formula semantics in each destination app before copying a workbook.

• VLOOKUP guide
• FILTER guide

• ONLYOFFICE Spreadsheet Editor — function documentation
• ONLYOFFICE’s official function-entry guide
• official array formula guide
• official changelog

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.