Glossary term
What is Lookup and key?
In Apex Flow Academy, "Lookup and key" means: A lookup finds one value in a list and returns a matching item from the same row. The value you search for is the key. It is taught in Microsoft Excel: Beginner to Advanced. Related terms include Tidy list, Exact and approximate match, Table and Criteria.
- 1 course teaches it
- plain-word definition
The facts
What is Lookup and key?
A lookup finds one value in a list and returns a matching item from the same row. The value you search for is the key.
Where is Lookup and key taught?
Lookup and key is defined in Microsoft Excel: Beginner to Advanced.
Which terms are related to Lookup and key?
Next to Lookup and key in the course glossaries: Tidy list, Exact and approximate match, Table, Criteria, Serial number (dates), Helper column, Number format and PivotTable.
Tidy listExact and approximate matchTableCriteriaSerial number (dates)Helper columnNumber formatPivotTable
The hard questions, answered straight
Bold questions people really ask. Each answer comes from the course data or a settled Academy fact.
Do I need experience before I learn Lookup and key?
It depends on the course. Each course that teaches it lists its own prerequisites, and all are listed at beginner level:
- Microsoft Excel: Beginner to Advanced: No earlier spreadsheet experience is needed.