Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to create dynamic named range with OFFSET in Excel
  • Find closest match in Excel
  • How to use Excel VLOOKUP Function
  • To count total rows in a range in Excel
  • How to get last column number in range in Excel

Data Analysis Examples

  • Chart Axes in Excel
  • Reverse List in Excel
  • Excel Frequency Function Example
  • Create Scatter Chart in Excel
  • Conditional Formatting Rules in Excel

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation specific characters only
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year
  • Excel Data validation exists in list

VLOOKUP by date in Excel

by

This tutorial shows how to calculate VLOOKUP by date in Excel using the example below;

Formula

=VLOOKUP(date,table,col,FALSE)

Explanation

To retrieve a value on a specific date from a table, you can use the VLOOKUP function.

In the example shown, the formula in F6 is:

=VLOOKUP(E6,B6:C11,2,0)

How this formula works

This is a standard VLOOKUP formula. It requires a table with lookup values (in this case, dates) to the left of the values being retrieved.

Worked Example:   Get nth match with VLOOKUP in Excel

The lookup value comes from cell E6, which must be a valid date. The table array is the range B6:C11, and the column index is 2, since the amounts are in the second column of the table. Finally, zero is provided for the final argument to force an exact match.

Worked Example:   VLOOKUP with numbers and text in Excel

The VLOOKUP function locates the date value for Sept 4, and returns the value at the same row in the second column: 12,500.

Worked Example:   VLOOKUP with multiple criteria in Excel

Note: the lookup value and the date values in the table must be valid Excel dates.

Post navigation

Previous Post:

Two-way lookup with VLOOKUP in Excel

Next Post:

VLOOKUP from another workbook in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to check if cell contains number in Excel
  • How to Check If A Cell Contains Specific Text in Excel
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • Split numbers from units of measure in Excel
  • How to count total words in a cell in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Basic timesheet formula with breaks in Excel
  • How to calculate Quarter of Date in Excel
  • Get project midpoint in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • Example of payment for annuity in Excel
  • Calculate interest for given period in Excel
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles