LibreOffice Calc
Tested
=XLOOKUP("SKU-103";D2:D6;E2:E6;"Not found")Exact match when match mode is omitted. Match mode 2 uses wildcards; 3 supports regex.
Eight spreadsheet programs · source-backed examples
Formula Migration Helper — Translate Spreadsheet Tasks
Choose a spreadsheet task, source program and destination program to compare documented formulas, practical alternatives, and migration cautions.
Choose the task you want to accomplish and the program you are moving from and to. The tool uses curated, sourced examples from our compatibility library. It does not parse arbitrary spreadsheet files, test formulas in your desktop application or automatically rewrite proprietary workbook formats.
Useful starting points include exact-match lookups, two-condition SUMIFS, IFERROR versus IFNA and joining text while skipping blanks.
Privacy: Selections run in your browser. No workbook is uploaded to this tool. Visit the editorial standards for our evidence labels and limitations.
Choose your migration
Example based on vendor documentation and previously recorded tests.
Example: XLOOKUP exact match
Zoho Sheet
Documented
=XLOOKUP("SKU-103";D2:D6;E2:E6;"Not found")Zoho documents match mode 2 patterns using regex-like syntax rather than simply treating it as identical to Excel-style wildcards.
Expected example result: Gamma
How to use a formula migration candidate
- Check the task: use the same test data and expected outcome in both programs.
- Confirm the version: read the destination entry's official documentation, especially for dynamic arrays and pattern matching.
- Recalculate: formulas are not executed here. Run them in the target spreadsheet and check no-match, blank and error cases.
- Reopen the saved file: verify that the formula survives ODS/XLSX export rather than being replaced by a cached value.
Browse the full comparison library
These links are rendered in the HTML even when JavaScript is unavailable.
- XLOOKUP exact-match lookup Lookups
- VLOOKUP exact-match portability Lookups
- COUNTIFS across spreadsheet programs Criteria
- INDEX + MATCH fallback Lookups
- Extract digits using regex Text
- Replace every numeric run Text
- SUMPRODUCT weighted totals Math
- FILTER with two conditions Arrays
- SORT numeric values ascending Arrays
- UNIQUE distinct region values Arrays
- SUMIFS with two conditions Criteria
- AVERAGEIFS for matching rows Criteria
- IFERROR versus IFNA Errors
- TEXTJOIN with a delimiter and blanks Text
- TRIM leading spaces without damaging identifiers Text
Verification and limitations
Comparisons are drawn from documented, task-specific examples. A "Native tested" label means the previously recorded Calc test was actually executed; "Documented" means vendor help was read, but the formula was not run in that application. "Alternative" means a different approach, without a claim of perfect parity. "Not researched" never means unsupported.
The tool does not accept workbook uploads, execute spreadsheet formulas or promise compatibility with all installed versions. It displays a candidate and its evidence for human testing.