Please enable JavaScript to view the comments powered by Disqus.


How lookup a date with VLOOKUP()

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.  

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


VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Lets chat on this