View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robotman@gmail.com is offline
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?