Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION WITH SUMS ABILITY | Excel Discussion (Misc queries) | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
Lookup Function | Excel Discussion (Misc queries) | |||
Lookup Function | Excel Worksheet Functions | |||
Lookup Function | Excel Worksheet Functions |