Need column name based on a given row and given answer

Greetings all-

I have an array of data (30 columns and 25 rows). I know the row name, and I know the number in the row (only one occurance of number per row) in the row that I want to match. What I need to do is search by row, then by number, and when it matches, give me the column name.

Any help would be appreciated!!

Try this:

=INDEX(B$1:AD$1,MATCH(number,INDEX(B$2:AD$25,MATCH(row_name,A$2:A$25,0),0),0))

Assumes your data is in A1:AD25, with headers in row 1 and in column A. Put the cell references in for row_name and for number.

Hope this helps.

Pete