Hi

I've got a table of numbers (mileages actually).

It's laid out with the months (Jan-Dec) as headers in rows B:M, and dates
1-31 in rows 2:32. The actual data is in B2:M32. Not all fields are populated.

What I want to do is extract the cell reference on criteria like MAX. For
example, if my highest mileage is in cell G14 I'd like a formula that would
extract the date from the row/column headers, in the case of G14 this would
be "Jun 13".

I've been playing with INDEX and MATCH and get nowhere but N/As!

Is what I'm after possible? All help much appreciated. Thanks.

Rob F