Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header
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
Видео Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header канала Leila Gharani
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
Видео Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Excel Index Match (the right way)Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique ValuesExcel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCTDiscover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)Return Multiple Match Results in Excel (2 methods)Excel Formula Lookup Multiple Results: Return headers based on matrix valuesExcel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way LookupAdvanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)Lookup & Return Multiple Values in One Cell in Excel (Easy Formula)Fully Dynamic Emails from Excel with a SINGLE FORMULA!Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEXSearchable Drop Down List in Excel (Very Easy with FILTER Function)Excel DGET Function Solves 2 of Your VLOOKUP ProblemsExcel Conditional Formatting the Lookup result in data table (Index Match)Excel Slicer Trick - Use Symbols instead of Text in Pivot SlicersINDEX and MATCH Functions in Excel to Return Value in Different Column than Search ValueLookup values across multiple worksheets: VLOOKUP / INDEX MATCH in ExcelSURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)