Lookup and reference functions
Lesson 2 / 9
Lesson video
The video is not available yet.
Lesson slides
not available yet
Lesson details
Lesson outcome
I can use lookup and IF functions to retrieve data efficiently.
Show transcript
The VLOOKUP function is used to retrieve data from another sheet based on a matching value.
Lookup and reference functions can be useful for working with sets of data efficiently.
Data can be stored in a database, which is an organised collection of data.
The IF function checks a condition and returns different outcomes depending on whether the condition is True or False.
The IF function is used to give user feedback in a spreadsheet.
Worksheet
not available yet
Quizzes
This quiz is not available yet.
What pupils see
The same lesson as a pupil sees it. You can set any section as work on its own.
- IntroductionPrepare · Not available
- Starter quizActivate · Not available
- Lesson videoLearn · Not available
- Exit quizCheck · Not available
This content is by Cashar and published under an open licence.