View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default 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.