007. Find Column Name with INDEX & SUMPRODUCT in Excel (Lookup Header Name based on selected value)

Traditionally, many of you have used Index + Match as an alternative to Vlookups. The problem is that in some cases it won't work. This is one of those examples. We will Find the Column Name with INDEX & Sumproduct in Excel - Using Sumproduct in an unconventional way to perform the lookup!

Advanced Lessons:
-----------------
Recap: Vlookup:   • 001. How VLOOKUP works in Excel with ...  
Recap Index & Match:    • 002. INDEX and Match Step by Step Exp...  
Lookup between 2 values:   • 005. INDIRECT Function easily Explain...  
Reverse Lookup:    • 006. REVERSE Lookups with INDEX and M...  


Beginner lessons:
-----------------
Vlookup:    • 036. Everything you need to know abou...  
Hlookup:    • 037. Everything you want to know abou...  
Xlookup:    • 063. RIP Vlookup...Xlookup, a more ef...  
Index:    • 038. Index and Match: Useful for righ...  
Match:    • 039. Index and Match: Useful for righ...  
Index + Match:   • 038. Index and Match: Useful for righ...  
sumproduct:   • 028. Calculating bills, total revenue...  
sumif:    • 017.Become a pro with SumIf to sum a ...  
Sumifs:    • 018. Only pros know how to use SUMIFS...  

Excel Sheet: https://mega.nz/file/yKI1gDbJ#KVnIzwa...
Contains 3 tabs: Sumproduct (this video), AGG (using another technique - next video) and a copy of AGG.


Content: lookup and return column header , sumproduct formula in excel with example , lookup return column header , microsoft excel , complex lookup problem , lookup header index , lookup header with index , lookup return header name , find header name based on lookup , find header name with index formula , find column name with index , index match to find column , index match to find column header , lookup to get the header in excel , formula to get column name , tutorial index lookup header

#Excel #MsExcel #exceltutorial