Help with easy LOOKUP formula please

  • Thread starter Thread starter Butch
  • Start date Start date
B

Butch

Could someone please tell me how to lookup a date in one row that matches a minimum number in another row?

Specifically -

Row 1 contains dates.

Row 2 contains the DOW averages for those dates.

At the end of Row 2 (say column Z) my formula finds the smallest (MIN) number in the row.

In Row 1, Column Z, I would like to put the LOOKUP function that finds the corresponding date of the value found in Row
2, Column Z.

In other words, I need to lookup the date in Row 1 that corresponds to the lowest DOW average found in Row 2.

I'm sure this is a piece of cake for those in the know, but I sure can't figure it out. Any help would be hugely
appreciated.
 
One way ..

Assume data is in A1:Z2

Try in say, AA1:

=INDEX($A$1:$Z$1,,MATCH(MIN($A$2:$Z$2),$A$2:$Z$2,0))

Format AA1 as date
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
Butch said:
Could someone please tell me how to lookup a date in one row that matches
Click to expand...
a minimum number in another row?
Specifically -

Row 1 contains dates.

Row 2 contains the DOW averages for those dates.

At the end of Row 2 (say column Z) my formula finds the smallest (MIN) number in the row.

In Row 1, Column Z, I would like to put the LOOKUP function that finds
Click to expand...
the corresponding date of the value found in Row
2, Column Z.

In other words, I need to lookup the date in Row 1 that corresponds to
Click to expand...
the lowest DOW average found in Row 2.
I'm sure this is a piece of cake for those in the know, but I sure can't
Click to expand...
figure it out. Any help would be hugely
 
Format Z1 as a date, and enter this formula:

=INDEX(A1:Y1,MATCH(Z2,A2:Y2,0))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Butch said:
Could someone please tell me how to lookup a date in one row that matches
Click to expand...
a minimum number in another row?
Specifically -

Row 1 contains dates.

Row 2 contains the DOW averages for those dates.

At the end of Row 2 (say column Z) my formula finds the smallest (MIN) number in the row.

In Row 1, Column Z, I would like to put the LOOKUP function that finds
Click to expand...
the corresponding date of the value found in Row
2, Column Z.

In other words, I need to lookup the date in Row 1 that corresponds to
Click to expand...
the lowest DOW average found in Row 2.
I'm sure this is a piece of cake for those in the know, but I sure can't
Click to expand...
figure it out. Any help would be hugely
 
Back
Top