Searching Data Table
 

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

Searching Data Table
 

What you're trying to do is possible, but I don't think it is with INDEX and
MATCH. Combining INDEX and MATCH allows you to return the value at an
intersection of a table (array), given a row and column number of the table
(array). It sounds like you're looking to do the opposite. I would look
here for some ideas: http://www.techonthenet.com/excel/formulas/match.php

I think what you want to do can be accomplished just with MATCH.

Dave


--
Brevity is the soul of wit.


"Rob F" wrote:

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