View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Search a Row and return Header Row Data

With the data to match in A2 and your 60 columns in b:bi

=index($b$1:$bi$1,match(a2,$b2:$bi2,0))



Aaron wrote:

I have a spreadsheet with 60 columns of data, each with a unique header
label. What formula do I use to search each row for specific data, then,
upon finding a match, return the header label data (i.e. the info in Row 1 of
that particular column.)

Thanks!


--

Dave Peterson