Need Help On Function

Need to look for matching dates form worksheet 1 "E1" within column "A" of worksheet 2 and find the value in column "C" and paste it into worksheet 1 "E2"


worksheet 1

A b c d e
1 1/5/05
2 10.00

worksheet 2

A B C D
1 DATE TOTAL
2 1/2/05 20.00
3 1/3/05 5.00
4 1/5/05 10.00

=LOOKUP(E1,Sheet2!B2:C11)

This function may help!!!!

Beware: if the function does not find the exact date it will choose the date closest above.