LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Butch
 
Posts: n/a
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP FUNCTION WITH SUMS ABILITY Jamesy Excel Discussion (Misc queries) 1 January 10th 05 03:39 PM
LOOKUP FUNCTION WITH SUMS VALUES Jamesy Excel Discussion (Misc queries) 3 January 10th 05 03:03 PM
Lookup Function Christopher Anderson Excel Discussion (Misc queries) 3 January 5th 05 03:38 PM
Lookup Function Ademar Excel Worksheet Functions 7 November 8th 04 11:50 PM
Lookup Function andibevan Excel Worksheet Functions 1 October 28th 04 03:29 PM


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"