vlookup using dates

[MH]

User trying to find the value on a certain date can enter that date (a1).
vlookup will search column A for the requested date and then return the
associated value that is in column b.... Column A10:a100 = dates. Column
B10:b100= values... =vlookup(a1,a10:b100,2) returns #N/A

 

[Gary''s Student]

#N/A means VLOOKUP can't find the matching date.

The date might not be in the table
The date in A1 or the dates in the table might not be true dates
(toggle CNTRL-~ to find out)