[Solved] VLOOKUP to find matching dates?

[CaliRay]

This should be so simple but I can't make it work.
Criteria: Column A is a list of dates in mm/dd/yyyy format. All column B cells contains either a number or is empty.
All column A cells are formatted as dates. Same for cell C2.
Cell C2 contains a test date. Cell D2 is empty.
I hope to use vlookup to search column A for a date in the range A2-A366 to find the date that matches C2 and return in D2 the value found in the cell to the right of the match found in the range A2:A366.
Example: If test cell C2 has a date of 6/10/1963, the matching date of 6/10/1963 is in A162 and B162 has some value, say -250, then cell D2 should be filled with the value found in B162, otherwise it should be filled with text of "Not Tested".

It seems from reading examples and other help requests this should be a very simple formula but everything I try comes back with #VALUE!.

[Zizi64]

It seems from reading examples and other help requests this should be a very simple formula but everything I try comes back with #VALUE!.

Please upload your ODF type sample file here.

[Villeroy]

=VLOOKUP(C2;$A$2:$B$366;2;0)

[CaliRay]

Date lookup ods file attached.

[CaliRay]

=VLOOKUP(C2;$A$2:$B$366;2;0)

Thank you. Tried the formula. It works fine. Is there an option to fill D2 with text when a number value is not found?

[Villeroy]

=IF(ISNA(VLOOKUP(C2;$A$2:$B$366;2;0));"Date not found in A";IF(NOT(ISNUMBER(VLOOKUP(C2;$A$2:$B$366;2;0)));"no number at matching date";VLOOKUP(C2;$A$2:$B$366;2;0)))