Hello:

I am using the dates in C to match with A, then putting the value from B in E. I have checked that all the data are in proper form, ie, A and C dates and B and D numbers, but still get the NA where the Vlookup is. My Vlookup is VLOOKUP(C3:C5,A3:B13,2,0). Any help would be appreciated.

A B C D E
6/28/2002 4.27 06/28/2002 3.85 #N/A
7/1/2002 4.32 07/05/2002 3.82 #N/A
7/2/2002 4.30 07/12/2002 3.88 #N/A
7/3/2002 4.24
7/5/2002 4.11
7/8/2002 4.29
7/9/2002 4.38
7/10/2002 4.36
7/11/2002 4.30
7/12/2002 4.39
7/15/2002 4.35