I have some columns A, B, C, D, E, F, G with some values in the rows below 2, 3, 4. I don't know if HLOOKUP is the correct answer for what I am trying to do but I want to have a function that looks at the values in row 4, finds the highest/greatest value, and then return the column name/label.
I am really rusty with Excel (this is 2011 by the way) so excuse me if it is a noob question. Don't waste your time telling me how easy it was to do. Just show me the solution.