# LookupLab > Reproducible spreadsheet-function benchmarks, sourced error fixes, and live in-browser playgrounds. Measured, not just described. LookupLab publishes original, reproducible performance benchmarks (HyperFormula engine, 100,000-row datasets), real-world error libraries sourced from Microsoft Support, Reddit, Stack Overflow and Super User, 8-platform compatibility matrices (Excel 2016-365, Google Sheets, LibreOffice, WPS, Numbers), and interactive playgrounds that run entirely in the browser. Every function page is a self-contained lab, not a reworded reference. ## Function pages - [VLOOKUP](https://formulalab.dev/excel-functions/vlookup.html): Syntax, live lookup playground, and an original 100,000-row speed benchmark vs INDEX-MATCH and XLOOKUP. - [XLOOKUP](https://formulalab.dev/excel-functions/xlookup.html): Modern lookup with a reproducible 100,000-row benchmark, 14 real error fixes, and full compatibility notes. - [INDEX-MATCH](https://formulalab.dev/excel-functions/index-match.html): Left lookups and two-way matrix lookups, 14 sourced error fixes, universal 8-platform compatibility. - [HLOOKUP](https://formulalab.dev/excel-functions/hlookup.html): Horizontal lookups, the row_index_num trap, 14 error fixes, and a live transpose playground. - [IFERROR](https://formulalab.dev/excel-functions/iferror.html): Lookup error handling with a live wrap toggle; tame #N/A without hiding real bugs. - [IF](https://formulalab.dev/excel-functions/if.html): The decision engine: short-circuit rule, IF vs IFS, a decision gallery, 14 real errors, and a live playground. - [IFS](https://formulalab.dev/excel-functions/ifs.html): Flat multi-condition branching: a first-TRUE-wins order gallery, the #N/A default trap and its TRUE() fix, IFS vs IF vs SWITCH, 10 sourced errors, and a live grading playground. - [SWITCH](https://formulalab.dev/excel-functions/switch.html): Exact-match dispatch: a first-match-wins gallery, the #N/A default trap, case-insensitive and text-vs-number gotchas, SWITCH vs IFS vs IF, 10 sourced errors, and a live status-code playground. - [IFNA](https://formulalab.dev/excel-functions/ifna.html): Surgical #N/A handling: a measured error-catch matrix (IFNA vs IFERROR vs ISNA/ISERR), the #N/A-only rule, the 0-vs-blank fallback trap, 12 sourced errors, and a live lookup playground. - [AND](https://formulalab.dev/excel-functions/and.html): The all-must-pass gate: a clickable measured truth table, number/text coercion, the eager-evaluation trap and the chained-comparison (0