With dates and rainfall in Sheet1 columns A &B
and dates and value in Sheet2 A&B then:
in C1 (sheet 1)
=VLOOKUP(A1,Sheet2!A$1:B$366,2)
Copy down as necessary

hth
--
Traa Dy Liooar

Jock


"Hutchy" wrote:

Hi,

I have two sets of data. The one contains rainfall for everyday of the year
and the other contains the closing prices of corn on CBOT on all trading
days. How can I get the CBOT prices for a specific day to match the rainfall
for that day so that the corresponding numbers appear in the same row?

Thnx
--
H