Important announcement

Dear visitor,

Please note that this OpenCourseWare platform will be replaced at the end of 2026 by a new platform (under the same url ocw.tudelft.nl).

Courses and their contents that are currently available the platform will partly be migrated. URL’s for this content will change and content might be unavailable for some time. In addition, some courses will not be available anymore.

If you are linking to specific courses on this platform (for instance for your students), please take timely measures to avoid problems with access. Possible actions are:

  • Download the materials to your local platform (laptop, server)
  • For educators only (including TU Delft lecturers): Contact us at ocw@tudelft.nl and inform us what course you are using in what context (institute, program, period of use, number of students). We will research (in collaboration with the authors of the course) and decide if we will migrate the course, and if yes, can supply you with a new url.

Thank you.

Home Courses Data Analysis: Take it to the MAX Course materials Lectures 2.2 Simple lookup

2.2 Simple lookup

Course subject(s) 2. Lookup and search

We take you step-by-step through a simple example of the VLOOKUP function, think of it like looking something up in a phonebook! Hopefully you identified the problem, Felienne will explain it here and move forward towards the VLOOKUP.

Video
Subtitles
Other

Sorry but there don't seem to be any downloads..

Subtitles (captions) in other languages than provided can be viewed at YouTube. Select your language in the CC-button of YouTube.

And with that we wrap up our introduction to VLOOKUP. In the next video we discuss the mysterious fourth parameter of this function.

Creative Commons License
Data Analysis: Take it to the Max by TU Delft OpenCourseWare is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at https://ocw.tudelft.nl/courses/data-analysis-take-it-to-the-max/.
Back to top
[sg_popup id=6]