Matching Dates and Associated Data

Hi all,

Here's what I'd like to do:

I have two sets of data (each set consisting of date/time + temperature, in two separate columns). The first list is rather sporadic in its time stamps (NOAA weather data) - the time jumps around a lot, with no set jump size. I have a second, more uniform set, with all of the time stamps. Basically, what I'd like to do is have Excel associate that particular time stamp with that particular temperature point, then go to the second set, look for the first time stamp, find it, then paste the associated temperature point next to it.

In other words:

I want Excel to say "1/1/2010 0:00 corresponds to 40". Then I want Excel to look in the second set for "1/1/2010 0:00), then paste 40 next to it.

I've seen this done in the Name Manager with matrices, but I'm not sure if that's the most efficient way to do it.

See the attached Excel file.
Any help would be greatly appreciated.
Let me know if I need to clarify anything.


Thanks.
-Reactant

I found the solution: the VLOOKUP function.

Thanks anyways.
-Reactant