How to extract corresponding data based on date in excel

As shown in the figure, if the date of 2017/9/18 is in the first row of the data area, the data in all columns of the first row will be displayed in the display area. If the date of 017/9/18 is in the 3rd row of the data area, the data in all columns of the 3rd row will be displayed in the display area.

(Recommended learning: html introductory tutorial)

Enter the following formula in B2 to F2: =VLOOKUP(TODAY() ,$A$3:$F$12,COLUMN(),1)

where today() returns the current date,

column() returns the current column value,

VLOOKUP (find value, search range, search column number, exact match or approximate match).

The overall meaning is to find today's date of TODAY() in the area $A$3:$F$12, and return the data corresponding to the current column value of COLUMN().

The last 1 represents precise search.

Recommended related tutorials: excel tutorial

The above is the detailed content of How to extract corresponding data based on date in excel. For more information, please follow other related articles on the PHP Chinese website!