Time filter

[fakhteh]

I want to find the exact value of the time that i have it in another column
i have 05 minute date time series and in column d i have date time that i want to find the value of it from the first time series( every 15 minutes)
THANKS SO MUCH

[Phuocam]

Trythis ...

=VLOOKUP(D1,$A$1:$B$35,2,0)

[The_Snook]

Hi fakhteh,

If I'm understanding your query correctly try the following in cell E1 and copy it down the range.

=VLOOKUP(D1,$A$1:$B$34,2,0)

Regards,

Snook