Hi all,
I have been a lurker of this forum for a few years and always managed to find the answer to my questions by perusing old posts. After hours of trying different index/match/sumif variations, then searching for an answer, I decided it was time to finally post a question.
I am trying to return the column heading (or column number) based on the intersection of a particular row and a particular value within that row. I've tried to illustrate the problem with a table below, obviously not the model I am working with, but should give you the idea.
I need to lookup "Row 3", the value 10, and return "Header 5", etc.
While the row value and header values are unique, the values that are populated in the table may repeat, as illustrated below.
Any ideas??
Header 1 Header 2 Header 3 Header 4 Header 5 Header 6
Row 1 1 2 3 4 5 6
Row 2 0 0 5 6 7 8
Row 3 0 0 0 9 10 11
Row 4 0 1 2 3 4 5
Row 5 1 2 3 4 0 0
Row 6 0 0 0 6 7 8
Bookmarks