I have a spreadsheet of weather data that I've collected over the past 30 years. Among other data, the columns on one sheet have a date, High Temperature & Low Temperature. On another sheet I have the days of the year listed along with the highest High Temperature, lowest High Temperature, etc. This gives me the value for each date, but I'm wondering if there is a way that I can also get the last date on which that value occurred.

Here's a sample of the data I have:

A B C
Date Max Min
1 01Jan11 0 -18
2 02Jan11 3 -15
3 03Jan11 4 -16
...
365 01Jan12 5 -13
366 02Jan12 -5 -23
367 03Jan12 -10 -30

On other sheet I have:

A B C D
MaxMax MinMax MinMin MaxMIn
01Jan 5 0 -18 -13
02Jan 3 -5 -23 -15
03Jan 4 -10 -30 -16

I achieve the above by a formula such as =Max(a1,a365) or Min(a1,a365) and so on for all of the past January 1st's so that I have the data that I'm looking for.

What I'd like to see is if I could do something like the following:

A B C D E F G
MaxMax Date MinMax Date MinMin Date MaxMIn
01Jan 5 01Jan12 0 01Jan11 -18 01Jan11 -13
02Jan 3 02Jan11 -5 02Jan12 -23 02Jan12 -15
03Jan 4 03Jan12 -10 03Jan12 -30 03Jan12 -16

Since I have several January 1st's I'll know on which one it occured.

Since I know the value, I tried doing a look up on that value in that dates cells, but I can't seem to get that to work. Here's what I thought would work, but it obviously does not:

=VLOOKUP(B10932,'WX Record'!{D575,D1279,D1644,D2009,D2374,D3075,D3440, D3805,D4171,D4536,D4901,D5266,D5632,,D213,D913,D27 22,D5992,D6357,D6722,D7088,D7453,D7818,D8183,D8549 ,D8914,D9279,D9644},1,FALSE)

Is there a different way to look up a value in different cells that are not contiguous? Is there a different approach I can take to get the data that I want?

Thank you for your time and assistance!