Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using MATCH with dates
...The "Feb-06" is generated from a formula using DATEVALUE, MONTH
and DAY vs. just having a date typed into a cell) what is the formula exactly? I guess the result is text and then it is not date and will not be found in a list of dates. If the result is really a date then the day which is is hidden (and potentially the time) of the date searched is not the same as the one in the list. Regards, KL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
Match Index | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
How To Match Dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |