Business & Industrial
Computers & Electronics
Consulting
E-Commerce Services
Reference
Lookup Multiple Values (Sort and Combine in a Single Cell or Row)
823 views
·
May 15, 2023
Visit Channel:computergaga.com
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
*** 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 ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
Show More
Show LessComments
loading text loading
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text