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
|