Launch
LookupLab
Visit
Example Image

LookupLab

Free Excel function labs where every example runs.

Visit
  • Learn Excel functions by running them, not reading them. LookupLab is a free reference where every example actually runs — 81 live, editable playgrounds powered by a real formula engine (HyperFormula), reproducible benchmark data, and sourced fixes for common errors like #N/A and #VALUE!. No signup, no paywall, nothing to install. Edit the cells, watch the result, and compare lookup approaches side by side. Free forever for all 81 labs; optional Pro adds advanced scenarios. Built for analysts, students, and anyone who learns Excel by doing.
Example Image
Example Image
Example Image
Example Image
Example Image

Features

  • 81 interactive function labs with live, editable playgrounds
  • Real formula engine (HyperFormula) — every example actually executes
  • Reproducible benchmark data, measured not described
  • Sourced fixes for #N/A, #VALUE!, #REF! and other common errors
  • Side-by-side lookup comparison: VLOOKUP vs XLOOKUP vs INDEX/MATCH
  • Free forever, no signup, zero external dependencies

Use Cases

  • Students learning lookup functions by experimenting live
  • Analysts verifying formula behavior before applying it to real data
  • Teachers demonstrating spreadsheet functions in class
  • Anyone comparing VLOOKUP / XLOOKUP / INDEX-MATCH speed and behavior


Comments

I built LookupLab because most Excel references show static examples you can't touch. Every lab here runs on a real formula engine (HyperFormula), so you can edit the cells and watch the result change — and the benchmark numbers are measured, not described. It started as a way to settle VLOOKUP vs XLOOKUP arguments with actual data, and grew into 81 free labs. No signup, no paywall on the core. Would love feedback from anyone who teaches or learns spreadsheets — especially which functions you'd want covered next.

Premium Products

Comments

I built LookupLab because most Excel references show static examples you can't touch. Every lab here runs on a real formula engine (HyperFormula), so you can edit the cells and watch the result change — and the benchmark numbers are measured, not described. It started as a way to settle VLOOKUP vs XLOOKUP arguments with actual data, and grew into 81 free labs. No signup, no paywall on the core. Would love feedback from anyone who teaches or learns spreadsheets — especially which functions you'd want covered next.

Premium Products