Premium Only Content

Excel Formula Lookup Multiple Results: Return headers based on matrix values
Aug 24, 2017 Excel Lookup Formulas
Download the workbook here: http://www.xelplus.com/complex-lookup-index-sumproduct/
Watch this video to find out my method of getting multiple lookup results in Excel. This example builds on the example shown in the previous video which has a matrix of apps which belong to different divisions. The apps are the values inside the matrix and the divisions are the headers. The aim is to find the header value based on the matrix value. Since the data in this example is not unique and an app can belong to more than one division, the aim is to come up with a formula that finds all the divisions one app could belong to.
✔ Alternate Solutions ✔
Watch Kevin's video to see 4 different approaches of solving this
2 with array formulas, 1 with helper columns and last one with a pivot table to normalize the date set: https://youtu.be/u4IcqcQP1FI
Watch Oz's Video from Excel on Fire here which shows how to solve this with a COUNTIFS function and the Power Query method: https://youtu.be/IwBYEXaOSOk
Another option that was suggested by Bill Szysz is: =TEXTJOIN(",", ,IF(H5=$B$5:$D$45,$B$4:$D$4,""))
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
12:40
Degenerate Jay
13 hours ago $0.62 earnedThe Perfect RoboCop Versus Terminator Game Needs To Be Made!
20.1K5 -
8:17
VSOGunChannel
16 hours ago $0.83 earnedYou Were Put on a Government Watch List || DECLASSIFIED
20.4K8 -
35:14
Steph & Kayls
18 hours ago $0.97 earnedSpicing Things Up: How To Navigate Adding A Third To The Bedroom | Ep. 4
24.3K11 -
28:59
Film Threat
13 hours agoTHUNDERBOLTS* EARLY REACTIONS | Film Threat After Dark
29.7K5 -
8:02:12
Rebel News
4 days ago $214.66 earnedELECTION NIGHT LIVE: Rebel News Canada coverage with Ezra Levant, Sheila Gunn Reid & Special Guests
446K246 -
1:24:54
Badlands Media
17 hours agoBaseless Conspiracies Ep. 130: Iberia Blackout, Green Energy Failures, and Grave-Robbing Government Experiments
95.6K33 -
2:12:50
FreshandFit
10 hours agoModern Men VS Modern Women
63.2K42 -
4:17:07
vivafrei
11 hours agoELECTIONS CANADA RESULTS LIVE STREAM WITH VIVA COMMENTARY!!!
139K148 -
2:39:37
TimcastIRL
12 hours agoDemocrat LAUNCHES IMPEACHMENT Against Trump Citing Deportation, Abrego Garcia Case | Timcast IRL
186K169 -
2:17:27
IcyFPS
10 hours agoA new legend rises.. Icy vs Teardrop | @playoffthegrid | Team MERC Grind |
34.5K6