Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search a Row and return Header Row Data
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search a Row and return Header Row Data
Here is a custom function
call with =GetHeader(10.50,A3:D8,1) where 10.50 is the data you arre looking for A3:D8 is range of cells to search 1 is the row of sheet youwant to get data from. Routine locates the column whre the data is found and then returns the data in the the same column for the row specified Function GetHeader(SearchData As Variant, Target As Range, RowNumber) For Each cell In Target If SearchData = cell.Value Then Exit For Next cell GetHeader = Cells(RowNumber, cell.Column).Value End Function "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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look up X and return a header Y | Excel Discussion (Misc queries) | |||
Search Column Data and Return Multiple Values across Row | Excel Worksheet Functions | |||
Search for a number in a table and return data of a specific cell | Excel Discussion (Misc queries) | |||
search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) | |||
Return Column header, if row value is > X | Excel Discussion (Misc queries) |