Combo recipes

Formulas that click together

Two or three functions nested to solve a real problem. Each recipe shows exactly how the inner call runs first, then hands its result to the outer one, step by step.

3combo recipes

More recipes coming soon

Combo recipe

INDEX + MATCH

Look up any direction, no column counting

=INDEX(D2:D6, MATCH("Maria Lopez", B2:B6, 0))

UsesindexmatchReplacesVLOOKUP

Combo recipe

IFERROR + VLOOKUP

Safe lookups with a friendly fallback

=IFERROR(VLOOKUP(A2, Products!A:C, 3, FALSE), "Not found")

Usesiferrorvlookup

Combo recipe

IF + AND

Branch on multiple conditions at once

=IF(AND(B2>50000, C2>=0.95), "Bonus", "No bonus")

Usesifand