LookupLab

About LookupLab

LookupLab is a free reference for Excel functions where every example actually runs. No signup, no paywall, nothing to install.

68 function pages10 side-by-side comparisons Live in-browser examplesOriginal benchmarksFree forever

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

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].