Lookup and Return Multiple Values - All versions + Bonus Trick

In this video, we cover three examples of an Excel formula to lookup multiple values. The formula examples can be used in all versions of Excel. In the first example, we use an array formula to lookup and return multiple values. In example 2 we combine the results in a single cell. This example requires Excel 2019 or higher. In example 3, we see an approach that works in all Excel versions to return multiple results and order them into different columns. We also see a neat Excel trick for copying a formula that uses table references. Excel formula to lookup multiple values in modern Excel - https://youtu.be/5XB7C_TF5LU Working with Absolute column and cell references in tables - https://youtu.be/JjYbuHa1YYQ The timings in the video are. 00:00 - Excel formula to lookup multiple values 02:37 - IF function to return the row of the lookup results 04:39 - SMALL function to order the row numbers 06:19 - Excel INDEX function to return multiple lookup values 07:46 - IFERROR function to handle the errors 09:40 - Combine lookup results in one cell 13:13 - Excel INDEX and MATCH with multiple criteria 17:41 - Correctly fill formula with table references