Uploaded August 2017 | Updated September 2026, 51 minutes ago

---

Get Excel file here: http://1drv.ms/1bYwrTa
myspreadsheetlab.com/video-00165-show-column-header-for-matrix-value
Look for text value in non normalized data, return column header.
00:00 Intro
00:14 Requirements
01:17 Factors to consider
02:08 Solution Comparison Grid
02:25 SOLUTION: Sumproduct or Array
03:06 SOLUTION: Simple helper formulas
06:38 SOLUTION: Normalize, index/match
------------------------------------
Update: I added Get & Transform solution in the Excel file.

Leila Gharani's original video: youtu.be/OJLfPc9YlqE
Leila Gharani's website: xelplus.com
Oz du Soleil's solution: youtu.be/IwBYEXaOSOk
My blog: myspreadsheetlab.com/blog