Another Lookup function, please
 

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

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




.

See: http://tinyurl.com/3upsk

Butch Wrote:
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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274762

please try the following
As row 1 contains dates(say A2:N2), & row 2 contains DOW averages (say
a3:n3), & minimum in o3,then put row 3 (a3:n3) first & row 2 (a2:n2) next in
ascending (or descending) order simutaneouly.
then follow this
=lookup(o3,a3:n3,a2:n2) which will give you the desired result.
K.S.Warrier

"Aladin Akyurek" wrote:


See: http://tinyurl.com/3upsk

Butch Wrote:
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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274762