=
FormulaCraft
Formulas
How-to
Fix errors
Pricing
Workspace
Auditor
Verify
Sign in
Get started
Formula workspace
Describe it, paste one to explain, or paste a broken one to fix.
Generate
Explain
Fix
Excel
Google Sheets
=IFERROR(INDEX($B$2:$B$6,SMALL(IF($A$2:$A$6="Alice",ROW($A$2:$A$6)-ROW($A$2)+1),2)),"")
.
⌘↵ to run
Generate formula
Workspace | FormulaCraft