VLOOKUP(...)
How lookup a date with VLOOKUP()
Used Functions
Category: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Practice VLOOKUP Formula at Sheetzoom
VLOOKUP formula at Microsoft help
0
The lookup process is basically the same as is for a number, because excel considers dates to be numbers. The lookup value is looked up in the left most column in a table and is returned from the given column index.