Posted to microsoft.public.excel.worksheet.functions

Enron

Posts: n/a

vlookup with date formats

Hi, I put a vlookup formula searching for a data corresponding to a date in a
table. It is only working with a european date format (dd/mm/yyyy) although
my regional settings are set to US. Once I change (on both tables) the date,
the vlookup doesn't work anymore ... really strange

Did someone already see that ?

Thanks

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
How do I create a schedule from a list of dates ?	Gavin Morris	Charts and Charting in Excel	2	October 28th 10 04:08 PM
importing csv files, problem with date formats	jiwolf	Excel Worksheet Functions	5	March 7th 06 12:48 AM
Copy Color Formats Based On Column Date Values	Naji	Excel Discussion (Misc queries)	0	January 11th 06 09:06 PM
Date formats	JR	Excel Discussion (Misc queries)	1	June 1st 05 12:04 AM
Date formats	Penco Excel User	Excel Discussion (Misc queries)	1	November 28th 04 09:11 AM

All times are GMT +1. The time now is 12:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us