2.5 Problem with VLOOKUP

Course subject(s) 2. Lookup and search

There are two reasons why VLOOKUP functions are not perfect: First, VLOOKUPs are slow for large data sets. Second, VLOOKUPs cannot look up in both directions.

Video

High1080p
Medium720p
Low360p

Subtitles

PDF English
SRT English
PDF Dutch
SRT Dutch
PDF German
SRT German
PDF French
SRT French
PDF Italian
SRT Italian
PDF Spanish
SRT Spanish
PDF Greek
SRT Greek
PDF Hindi
SRT Hindi
PDF Chinese
SRT Chinese

Other

SlidesPDF
PodcastMP3

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.

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/.