This video demonstrates how to use the FILTER function in Microsoft Excel to lookup and return all corresponding values. VLOOKUP will only return the first corresponding value from another table but the filter function allows you to return each corresponding value along with its associated record.

The video features the following functions: FILTER, SORT & UNiQUE

You will also learn how to make a dynamic drop-down.
------------------------