I want to be able to grab a value in a row adjacent to the maximum of another column. If the maximum value of column C was in row 30, I want to be able to return the value of cell A30.

Any help would be greatly appreciated.