2.6 Index and match
Course subject(s)
2. Lookup and search
Learn the alternative to the wonderful VLOOKUP function, the INDEX-MATCH strategy! INDEX-MATCH has much better performance and gives you much more freedom with what to return.
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/.