Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header
Jul 20, 2017 Excel Lookup Formulas
Download the workbook here: http://www.xelplus.com/excel-reverse-matrix-lookup/
Learn advanced lookup techniques by using Index & Match to lookup a column header based on the values inside the matrix and the row header. In this example, the combination of row header and the values inside a matrix create a unique key, which we can use to find the column header. To solve this Excel problem, we will take a look at INDEX & MATCH and use two sets of INDEX MATCH to get our result.
★ 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
-
LIVE
The Dan Bongino Show
2 hours agoIs The FBI Watching MAGA Voters? (Ep. 2244) - 05/07/2024
107,149 watching -
LIVE
Right Side Broadcasting Network
40 minutes agoLIVE: House Foreign Affairs Committee Hearing on Crisis of Democracy, Freedom, & Rule of Law
2,226 watching -
LIVE
Benny Johnson
46 minutes ago🚨 FBI CAUGHT STAGING & TAMPERING With Evidence in Trump Raid 'Crime Scene Photo' | Jack Smith JAIL?
4,947 watching -
53:34
Steven Crowder
2 hours ago🔴 DEPORT THEM ALL! How Trump’s Historic Mass Deportation Plan Is Going To Work
46.1K188 -
LIVE
Mostly Sports With Mark Titus and Brandon Walker
19 hours agoMostly Sports With Mark Titus and Brandon Walker Presented by Jägermeister | EP 162 | 5.7.24
1,130 watching -
2:09:31
Matt Kohrs
11 hours agoBiden Drops in Polls, College Turmoil & Breaking Market News || The MK Show
7.15K2 -
LIVE
Wendy Bell Radio
6 hours agoI'll Go To Jail For America!
12,944 watching -
44:50
Rethinking the Dollar
1 hour agoPredicting the Next Crash? Decoding the Secrets of the Yield Curve Inversions | Tuesday Morning Check-In
483 -
1:39:56
The Podcast of the Lotus Eaters
6 hours agoThe Podcast of the Lotus Eaters #909
21.4K11 -
2:00:27
AP4Liberty
3 hours agoFrat Boys Fight The College Gynocracy For America!
15.5K6