Posted to microsoft.public.excel.worksheet.functions

Sambonator Sambonator is offline

external usenet poster

Posts: 2

Comparing dates from VLOOKUP functions not working right

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing dates	Gareth.Evans	Excel Worksheet Functions	0	March 26th 09 08:54 AM
Comparing Dates	fubdap	Excel Discussion (Misc queries)	3	September 27th 07 03:53 PM
COMPARING DATES with nested IF not working- Syntax is correct though	Richard Flame	Excel Discussion (Misc queries)	2	July 12th 06 07:04 PM
VLOOKUP & Dates: Why is this Formula working?	Ali	Excel Worksheet Functions	1	January 18th 06 01:37 PM
Comparing dates	Debbie F	Excel Worksheet Functions	7	September 7th 05 11:57 AM

All times are GMT +1. The time now is 05:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us