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