Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1532.xlsx
In this video see how to use VLOOKUP to retrieve an entire record using two methods: 1) FILTER Function and 2) VLOOKUP, COLUMNS and Table Header Code.

1. (00:05) Introduction
2. (01:16) FILTER Function
3. (03:18) VLOOKUP, COLUMNS and Table Header Columns
4. (07:57) Summary

Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) https://www.youtube.com/watch?v=7jJMDGZpjSk