Pathwise

Manuals / Spreadsheets for QA & Analysis / Chapter 3

Core · intermediate · ~35 min · Chapter 3 of 3

Lookups

XLOOKUP/VLOOKUP to join id → name without a database.

Path progress
83%

Step 1 of 2

Key idea

Lookups join tables by key. Prefer XLOOKUP when available.

Key ideaDrag stickies · tap for tips
Study mapDrag stickies · tap for tipsKeep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Assert the UIdrag · tap →Retry wiselydrag · tap →Seed datadrag · tap →Close the loopdrag · tap →Keep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Pathwise hackdrag · tap →Key ideadrag · tap →Go deeperdrag · tap →Follow the dashed drag · tap →
Docs

Quick check

When sheets hurt…

Do this now

Write 3 notes on: Lookups.

Was this step clear?
Chapter learning outcomes
  • XLOOKUP
  • Errors
  • When to use SQL instead

Clear these before you leave

Next, learn…

Same neighborhood as Spreadsheets for QA & Analysis — keep the momentum.

FoundationsJavaScript
FoundationsTypeScript
FoundationsPython
FoundationsSQL