I think that you have rounding errors. If I copy and paste the Dates/Times
from you post into Excel I get no #N/A but if I highlight C2:C3 and drag
down in C5 I then get the #N/A in D4, although the Date/Time looks exactly
the same and both A4 & C4 show a value of 39595.375 when formatted as
General. However, =C4-A4 returns 5.7872966863215E-08 indicating that the
incrimenting due to the dragging down has induced a tiny error.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Nev Wood" wrote in message
...
Hi,

I have a spreadsheet which contains user counts on the hour every hour.
However, I know that there are gaps in my data and because I want to
compare
this data with data from other sources I have used the following solution:

A B C D
Recorded DateTime Recorded Counts All DateTime All Counts
27/05/2008 07:00 3 27/05/2008 07:00 3
27/05/2008 08:00 4 27/05/2008 08:00 4
27/05/2008 09:00 6 27/05/2008 09:00 #N/A
27/05/2008 11:00 6 27/05/2008 10:00 #N/A
27/05/2008 12:00 10 27/05/2008 11:00 #N/A
etc.

Columns A & B contains all the data that I have, column C contains all
dates
and times in this period whether there is a corresponding value in column
A
or not, and column D contains a formula which is designed to show the
value
from column B if there is data for that date and time or #N/A if not.

The formula I am using in cell D2 is:

=VLOOKUP(C2,A$2:B$1035,2,FALSE)

I would expect to see #N/A in cell D5 as there is no data for 10am, but I
would expect to see values in D4 & D6 as there are values for 9am and
11am.
If I click in the formula bar for cells C4 & C6 and then press enter Excel
gives me the value I expect, and therefore I suspect there is some problem
with Excel not recognizing that the contents of A4 are the same as C4
(although it has worked for rows 2 and 3!!).

Please help, this is driving me crazy!!

--
Nev