Filter like data..help please
 

Hi everyone,

I have two worksheets, the first is a set of date/times and values like
this:
DATE_TIME VALUE
2006-01-01 0:15 5.798
2006-01-01 0:30 5.804


and the other worksheet is and 'Override" table where the tech inputs a
value for the entire day that nullifies the data from the first table.
Like this

OR_DATE VALUE
2006-01-01 -999.999

I need to have a column in the first worksheet where if any if the
values from worksheet#1 and included in the date from Worksheet #2,
the -999.999 value is show.

It doesn't have to overwrite the worksheet#1 data, just have the
-999.999 show up in a column beside it.

I bet it is easy but I am sure stuggling with it as the date values
don't exactly match up. Any help would be GREATLY appreciated.

Derek


--
DerekF
------------------------------------------------------------------------
DerekF's Profile: http://www.excelforum.com/member.php...o&userid=34882
View this thread: http://www.excelforum.com/showthread...hreadid=546272

Filter like data..help please
 

Say your "other sheet" is named Override
=VLOOKUP(INT(A2),Override!A2:B999,2,0)
will return any value entered in Override sheet column B for matching date
(any hour)

Cheers,
--
AP

"DerekF" a écrit dans le
message de news: ...

Hi everyone,

I have two worksheets, the first is a set of date/times and values like
this:
DATE_TIME VALUE
2006-01-01 0:15 5.798
2006-01-01 0:30 5.804


and the other worksheet is and 'Override" table where the tech inputs a
value for the entire day that nullifies the data from the first table.
Like this

OR_DATE VALUE
2006-01-01 -999.999

I need to have a column in the first worksheet where if any if the
values from worksheet#1 and included in the date from Worksheet #2,
the -999.999 value is show.

It doesn't have to overwrite the worksheet#1 data, just have the
-999.999 show up in a column beside it.

I bet it is easy but I am sure stuggling with it as the date values
don't exactly match up. Any help would be GREATLY appreciated.

Derek


--
DerekF
------------------------------------------------------------------------
DerekF's Profile:
http://www.excelforum.com/member.php...o&userid=34882
View this thread: http://www.excelforum.com/showthread...hreadid=546272