Looking for a Max Function that returns a column heading

[ExcelDavid]

Let's say I have data that looks like this grid below. Each color represents a column heading and each number is a data point within that column.

Blue Red Green Yellow
18 27 15 36
56 41 3 22


Can I write a formula that would do the following 2 things with the data in this format:

1. Find the max of the data...simple =Max(...) formula
2. Use the max to return the column heading. In this case the max is 56 so the value I want to return is "Blue"

Thanks

Edit: The spacing isn't right after posting, but you get the idea.

[azumi]

Maybe something like this?

All is Array Formula

cheers

[ExcelDavid]

Ok so I tried your formula but was having difficulty because ultimately I'm trying to access a different sheet...sorry for the confusion.

I've attached and example of what I'm trying to accomplish. Ultimately I want the yellow highlighted cell to return the day of the week associated with the max in the cell to the left, based on data from the 1905 tab.

Can this be done?

Thanks,

[azumi]

=INDEX('1905'!A1:G1,,MAX(IF('1905'!A2:G20=B4,COLUMN('1905'!A1:G1)-COLUMN(A2)+1)))

Array Formula