LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default Using MATCH with dates

I'm having trouble getting a match with dates for some reason:

For example:

Jan-06 Feb-06 Mar-06 ...etc.
in A1-A3 etc...

And "Feb-06" in B1
(Note: The "Feb-06" is generated from a formula using DATEVALUE, MONTH
and DAY vs. just having a date typed into a cell)

=MATCH(B1,A1:A3,0)
should give me "2", but for some reason it doesn't find the matching
date.

Am I not able to use a reference to another cell as the lookup_value?
Even if I do type in direct dates into the reference cell, it doesn't
match.

Any ideas?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Pre-1900 dates Richard Gadsden Excel Discussion (Misc queries) 1 March 26th 06 12:46 AM
Match Index cjjoo Excel Worksheet Functions 3 October 25th 05 09:33 AM
2 digit year in dates return 19xx not 20xx moranbo Excel Discussion (Misc queries) 1 September 7th 05 01:44 AM
How To Match Dates Robert Gillard Excel Discussion (Misc queries) 1 February 26th 05 11:43 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"