Lookup and Return Multiple Values - All versions + Bonus Trick

Опубликовано: 11 Июль 2021
на канале: Computergaga
41,304
356

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 -    • Lookup Multiple Values (Sort and Comb...  

Working with Absolute column and cell references in tables -    • Excel Tables - Absolute Column and Ce...  

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

Download the workbook to follow - https://www.computergaga.com/_excel/f...

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1  


Смотрите видео Lookup and Return Multiple Values - All versions + Bonus Trick онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Computergaga 11 Июль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 41,30 раз и оно понравилось 35 людям.