matching different dates and their values

**tehsky** · 09-07-2010, 12:09 AM

Hello, im having trouble matching different excel dates with values.
I have a list of two data, say the daily spot oil price and daily closing prices of a stock.
I have the past 8 years data on both and values on each date, but on some days, either market was closed due to holidays and whatnot.

Like my oil prices start 2 jan 2003 and my stock starts 1 jan 2003, and then some are the same and some different. I want to match 1 date with the two values corresponding to the stock price and oil price without having to individually delete the dates from 2003 to 2010 where dates do not match

How would i do this in excel?
Ive attatched the file for further clarification.
Cheers.!

**ConneXionLost** · 09-07-2010, 02:30 AM

Try this,

Cheers,

**DonkeyOte** · 09-07-2010, 02:39 AM

A slightly different alternative to the above but using the same setup

A2:D2: enter 0

G3:
=IF(LOOKUP($F3,$A$2:$A$1988)=$F3,LOOKUP($F3,$A$2:$B$1988),"")
copied down

H3:
=IF(LOOKUP($F3,$C$2:$C$1988)=$F3,LOOKUP($F3,$C$2:$D$1988),"")
copied down

the above utilises binary search given the data is sorted by date and should calculate a bit quicker as a result.