because "2003" < 2003

try
(--TEXT(Full!$A$1000:$A$2000,"yyyy")=A1)

--
Regards,
Tom Ogilvy

"Michael168" wrote in message
...

Hi! Frank Kabel,
Yes, it work for month but not for the year.

A1=2003
(TEXT(Full!$A$1000:$A$2000,"yyyy")=A1)

Why ? Any Idea?

Thanks
Michael

Frank Kabel Wrote:
Hi
as Tom said. Don't do this. But as an alternative try:
(TEXT(Full!$A$1000:$A$2000,"MMM")=B1)


--
Regards
Frank Kabel
Frankfurt, Germany




--
Michael168
------------------------------------------------------------------------
Michael168's Profile:
http://www.excelforum.com/member.php...nfo&userid=605
View this thread: http://www.excelforum.com/showthread...hreadid=274495