Before the capstone
Which function should I use?
What kind of problem am I looking at: one record, a position, an intersection, or every matching record?
| Business need | Best starting point |
|---|---|
| Find one record and return a value | XLOOKUP |
| Return several fields from one matched record | XLOOKUP |
| Find where something occurs | XMATCH |
| Return something based on a calculated position | INDEX + XMATCH |
| Row + column intersection | INDEX + XMATCH + XMATCH |
| Return every record meeting a condition | FILTER |
Start with the result you need. XLOOKUP returns one matched record; FILTER returns all qualifying records.
Concept Overview
Excel Simulation
Completed
Complete Demo to Unlock