VLOOKUP Dates (VLOOKUP for a Date from Data) in Excel (Formula)

You can also use VLOOKUP to lookup for a date from the date, and then get a value from the same row in the corresponding column. To do this you need to specify a date within the VLOOKUP, or you can also specify it directly into it.

Use VLOOKUP with Dates

You can use the below steps:

1. First, enter the VLOOKUP function in a cell.
2. After that, in the first argument, refer to cell D2 where you have the date to lookup for.
3. Now, in the second argument, specify the range A1:B13.
4. Next, in the third argument, enter 2 as you want to get the values from the second column.
5. In the end, in the fourth argument, enter 0 to perform the exact argument.

=VLOOKUP(VALUE(D2),A1:B13,2,0)

Entering Date Straight into the VLOOKUP

You can also insert a date straight into the function. See the example below:

=VLOOKUP(DATEVALUE("02-Dec-2022"),A1:B13,2,0)

Points to Note

1. Excel stores date as a number, and the date you are looking up and dates in the data need to be valid according to Excel’s date and time code.
2. If you want to insert a date within the function, you need to use the DATEVALUE function to convert the inserted date into a valid Excel date.