In this formula

=VLOOKUP(1/1/2001,A1:C4,3)

1/1/2001 is not interpreted as a date but as 1 divided by 1 divided by
2001. TRy either

=VLOOKUP(DATE(2001,1,1),A1:C4,3)

or

=VLOOKUP("1/1/2001"+0,A1:C4,3)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=566336