MATCH Function in ONLYOFFICE Spreadsheet Editor: Formula, Examples & Troubleshooting
Learn the MATCH formula in ONLYOFFICE Spreadsheet Editor: find the relative position of a matching key, with reproducible examples, expected answers and compatibility cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in ONLYOFFICE Spreadsheet Editor. How formula examples are checked
Quick answer: Use MATCH to find the relative position of a matching key. The example below supplies exact inputs and independently calculated expected results, so you can check your formula before replacing the demonstration values with real workbook data.
Verification: The function is covered by a vendor reference or its published formula catalogue. The worked outputs here are independently reasoned, not screenshots or native test results from ONLYOFFICE Spreadsheet Editor. Check release-specific support and argument details in the referenced vendor help.
Syntax and arguments
=MATCH(search_key, range, [search_type])
Look up a value in one row or column; exact-match search type is 0. In formula syntax, square brackets mark optional arguments; do not type square brackets into an ordinary formula unless the particular function requires array notation. The separator shown is for the example locale and might change with spreadsheet settings.
When to use it: Use INDEX(MATCH(…)) when you want the result itself, not just its position.
Prepare the example inputs
Create a new ONLYOFFICE Spreadsheet Editor workbook, paste the values as actual numeric and text cells, and select a result cell outside the input range. English comma-delimited formula examples are shown.
For the formulas that reference cells, enter this small dataset into A1:F9 (the first row contains headings). The Amount and Units columns are numbers; the team, status, item and agent columns are text. Keep the calculation cell outside A1:F9 so it cannot overwrite an input.
| Row | A · Item | B · Team | C · Status | D · Amount | E · Units | F · Agent |
|---|---|---|---|---|---|---|
| 1 | Item | Team | Status | Amount | Units | Agent |
| 2 | Pen | East | Paid | 120 | 12 | Ana |
| 3 | Pad | West | Pending | 75 | 5 | Bo |
| 4 | Box | East | Paid | 210 | 7 | Ana |
| 5 | Tape | North | Paid | 90 | 0 | Cy |
| 6 | Folder | West | Paid | 150 | 3 | Bo |
| 7 | Pen | East | Pending | 60 | 8 | Dee |
| 8 | Pad | West | Paid | 125 | 12 | Ana |
| 9 | Box | North | Pending | 80 | 4 | Cy |
Worked example: exact formula and expected output
=MATCH("Box",A2:A9,0)
Expected result: 3. Box first appears as the third value of A2:A9, at A4.
- Select an unused output cell (for example H2 if the practice table occupies A1:F9).
- Enter the formula exactly as shown, including the opening equals sign and quoted text.
- Compare the displayed answer to the expected result, then inspect the source cells if it differs.
For a range formula, the row numbers include data rows only unless the example explicitly refers to headers. A result that looks plausible may still be wrong if it references the wrong column.
Second example: a different input
=MATCH("West",B2:B9,0)
Expected result: 2. West first occurs as the second team value, at B3.
Use the other example as a control to check the function’s second input shape. Do not overwrite any of the data rows when entering array-producing formulas.
Important edge cases and a common mistake
Watch out: The default matching type in many spreadsheets is approximate; use 0 for unsorted text keys.
The software’s current published function categories establish documentation coverage, not operation in each self-hosted build; release-specific confirmation is recommended.
Troubleshooting in ONLYOFFICE Spreadsheet Editor
Check that calculation cells are formatted appropriately and ranges match the intended source data. Review formula bar and errors inside ONLYOFFICE; values can differ after import if their types or locale changed.
If you get the wrong answer but no error, try these checks in order: (1) evaluate the simplified first example; (2) confirm the cell values and data types; (3) check the exact row and column boundaries; (4) verify quoted text, comparison operators and separators; (5) only then add more criteria or nested functions.
For a reproducible comparison with another spreadsheet product, use the same input values in both applications and record the installed version and locale. Different default matching behavior or handling of empty values can be a migration issue rather than a mathematical disagreement.
Moving this formula between spreadsheet programs
ONLYOFFICE offers Excel-style workbooks and many function names, but verify version support and behavior before relying on dynamic array results or imported formulas.
Related guides already published for this function: Microsoft Excel | Google Sheets | WPS Spreadsheet | Collabora Office Calc | LibreOffice Calc
If a comparison tool says Not researched here, that means we do not yet have a checked guide for that software. It does not mean the software lacks this function. See the 12-program comparison tool for a guide-coverage matrix.
Official reference and editorial verification
- ONLYOFFICE — official list of spreadsheet editor functions
- Function comparison tool
- How we verify function guides
Evidence level: Vendor-published function catalogue / formula overview, checked for this editorial batch on October 11, 2026; example outputs verified by direct reasoning/arithmetic where applicable. No execution in ONLYOFFICE Spreadsheet Editor was performed. Some platform-, language- and release-specific edge cases remain for native testing.