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
-
54:17
Microsoft Excel Full Course
3 years agoExcel 365 Part 12 – Lookup Functions
71 -
13:26
user329
3 years agoVLOOKUP FUNCTION IN EXCEL / SPREADSHEET
28 -
4:40
Kcc23
3 years agoHow to Search in Excel Sheet (From Basic to Advanced)
5 -
28:56
Excel For Freelancers
3 years agoHow To Filter Excel Table Data Just By Entering Text In The Header
24 -
2:23
RahimZulfiqarAli
1 year agoVLOOKUP with Dynamic Table Array using INDIRECT Function in Microsoft Excel
4 -
6:52
OATtech
2 years agoFuzzy LookUp in Excel
52 -
2:50
Realworldexcel
1 year agoVLOOKUP in Excel - Quick Tutorial
366 -
26:04
Understanding Linear Algebra
3 years agoWhat do Elementary Row Operations do to the Determinant of a Matrix
31 -
17:40
djae1991
2 years agoMatrices | Row Echelon Form | Multivariable Linear Systems and Row Operations (Jae Academy)
17 -
1:51
syeduddin1786
1 year agoHow To Use The Vlookup Function In Excel.
277