Good Morning All,
I've tried numerous Index, VLOOKUP, MATCH, HLOOKUP functions to try and make this work. UNfortunately, I can't.
If there is a macro, that'd be awesome.
The problem I'm having is that I'd like to have a column header be returned for rows of data by looking at a particular cell range and only return the column header that contains the value "1".
I've attached a file to show you my dilemma.
Any help would be greatly appreciated.
Bookmarks