Please enable JavaScript to view the comments powered by Disqus.


VLOOKUP(...B12,A4:B10,2,0)

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

Syntax

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

Lets chat on this