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:
- First, enter the VLOOKUP function in a cell.
- After that, in the first argument, refer to cell D2 where you have the date to lookup for.
- Now, in the second argument, specify the range A1:B13.
- Next, in the third argument, enter 2 as you want to get the values from the second column.
- 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
- 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.
- 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.