Lookup Multiple Values (Sort and Combine in a Single Cell or Row)

In this video, we look at how to lookup multiple values in modern Excel with the excellent FILTER function. The FILTER function makes the task of creating a lookup that returns multiple results easy. Previous this was a frustrating task for Excel users. An introduction to the awesome FILTER function - https://youtu.be/kdl3mNEyIRE We also see how to sort the returned results and combine them into a single cell or row. There are three formula examples that lookup multiple values in this video. Download the workbook to follow - https://www.computergaga.com/_excel/files/365-functions/return-multiple-results-new.xlsx Timings of the video are; 00:00 - Lookup multiple values with FILTER 03:18 - Combine results in one cell 07:52 - Sort by another column and combine in a row 12:51 - Closing words Find more great free tutorials at; https://www.computergaga.com