How to return a Column Header
I have several columns with rows of data in them. For example
_____Header1_____Header2_____Header3_____
_____Data1_______Data2_______Data3_______
What I want to do is search for "Data2" text, and return that Column's
header, for instance, in this example, searching for "Data2" would yield
"Header2".
What formula should best be used?
Thanks.
|