Hi!
Try this:
Dates in A1:H1
Dow in B1:H1
Format the target cell as DATE:
=INDEX(A1:H1,MATCH(MIN(A2:H2),A2:H2,0))
This will return the corresponding date that matches the
*first* instance of the min value.
Biff
-----Original Message-----
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 DOW averages.
In Row 2, Column 30 I have placed the minimum found in
the row. In column 31 I would like to put the
corresponding date of the lowest DOW number in the row.
So, I need to lookup the date in Row 1 that corresponds
to the minimum DOW average found in Row 2.
I'm sure its a piece of cake for those in the know, but I
can't figure it out.
--
Thanks.
- Butch, Pennsylvania
.
|