View Single Post
  #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