Matching dates
 

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

Matching dates
 

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

Matching dates
 

Say your price set is in sheet Prices, date in column A, price in column B
rain set is in sheet Rain, date in column A, rain in column B

then in column C of sheet Rain
=VLOOKUP(A2,Prices!A:B,2,FALSE)

Regards,
Stefi


€žHutchy€� ezt Ã*rta:

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