Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Excel Pie Chart
  • How to create dynamic reference table name in Excel
  • How To Insert and Customize Sparklines in Excel
  • How To Filter Data in Excel
  • Managing Conditional Formatting Rules in Excel

References

  • Create hyperlink with VLOOKUP in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Count rows that contain specific values in Excel
  • How to get address of first cell in range in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Data Validations

  • Data validation must not exist in list
  • Excel Data validation unique values only
  • Excel Data validation require unique number
  • Excel Data validation with conditional list
  • How To Create Drop-down List in Excel

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.

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.

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

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

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

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

Logical Functions

  • SWITCH function example in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Steps to create Dynamic calendar grid in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Get week number from date in Excel
  • Calculate expiration date in Excel
  • Count dates in current month in Excel

Grouping

  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • Map text to numbers in Excel
  • Group arbitrary text values in Excel
  • If cell contains one of many things in Excel

General

  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
  • How to generate random times at specific intervals in Excel
  • How to generate random number weighted probability in Excel
  • How to calculate project complete percentage in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning