Home  >  Article  >  Topics  >  How to extract corresponding data based on date in excel

How to extract corresponding data based on date in excel

王林
王林Original
2020-03-10 16:47:2446376browse

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.

How to extract corresponding data based on date in excel

(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.

How to extract corresponding data based on date in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn