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

- Written by Puneet

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.

vlookup-for-a-date

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.
use-vlookup-with-dates
=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)
entering-date-into-vlookup-function

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.

Get the Excel File

Leave a Comment