About LookupLab
LookupLab is a free reference for Excel functions where every example actually runs. No signup, no paywall, nothing to install.
Why we built it
Most Excel function pages show a formula and a screenshot. You cannot tell whether it really works, what happens on edge cases, or how it compares to the alternative — without opening Excel and testing it yourself. LookupLab closes that gap: each page embeds a live grid powered by the open-source HyperFormula engine, so you can edit the inputs and watch the result recalculate instantly, right in the browser.
What makes it different
- Tested, not asserted. Worked examples and error/edge-case tables are computed with a real formula engine and baked into the page, then re-checked in a live browser.
- Original measurements. Lookup-family pages include benchmark data we generated ourselves (e.g. lookup cost across table sizes), labeled with method and scope.
- Honest comparisons. The VLOOKUP vs XLOOKUP and XLOOKUP vs INDEX MATCH pages show where each function wins and where it breaks, not a marketing verdict.
- Agent-readable. The site ships an llms.txt index and structured data so AI assistants can cite the pages accurately.
Methodology
Examples are evaluated with HyperFormula, an open-source spreadsheet engine. We pin a version, compute the truth values, and verify each page's interactive grid against them in a headless browser before publishing. Where Excel and HyperFormula differ, the page says so. Benchmarks are indicative of the browser engine, not Excel's native speed.
Who it is for
Analysts, finance and operations teams, students, and anyone who writes spreadsheets and wants a fast, trustworthy answer to "how does this function behave?" — including people learning modern dynamic-array functions like XLOOKUP, FILTER, and UNIQUE.
Free, and how it stays free
LookupLab is free to use with no account. It is an independent project; if it grows, we may add optional paid resources or sponsorships, but the function reference will remain open.
Contact
Feedback, corrections, and function requests are welcome: [email protected].