Matching dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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:
 
Back
Top