Sounds like the result of your lookup formula in A1 is a TEXT string and is
not a true Excel date. What result do you get from this formula:

=ISNUMBER(A1)

If A1 contains a true Excel date that formula will return TRUE.


--
Biff
Microsoft Excel MVP


"Sambonator" wrote in message
...
I have a spreadsheet with a bunch of VLOOKUP functions that pull dates from
different sheets.

When I try to compare the dates I get incorrect results.
E.g. Vlookup Results in A1 shows 5/15/2009, A2 shows 6/1/2009.
When I compare A1 to A2, =IF(A2A1,TRUE,FALSE) I get FALSE.
If I manually type in 5/15/2009 into B1 and 6/1/2009 into B2, and I do
=IF(B2B1,TRUE,FALSE) I get TRUE.

What might be going wrong here?