=
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
=INDEX(B2:B5,MATCH(TRUE,EXACT(A2:A5,D2),0))
.
⌘↵ to run
Generate formula
Workspace | FormulaCraft