# To obtain current day's value

#### Muthukrishnan V

##### Board Regular
Office 365

Sheet1 Column A6:A55 contains dates in DD-MM-YYYY format in
chronological order. Presently this A25 contains date 03-09-2020, i.e. today.

Sheet1 Column B6:B55 contains numbers in numerical format and
the number is filled in on daily basis. Therefore as of today B6:B25 have
been filled. B26:B55 are bank and will be filled in future.

My requirement: Cell Sheet2!C15 should show sheet1!B25 (Today's entry).
(Tomorrow this Cell sheet2!C15 should show sheet1!B26)

I request you to kindly advise me the formula in Cell Sheet2!C15.

Thanking you

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### MARK858

##### MrExcel MVP
If your dates are exact dates (i.e. no time part) then you can just use an index/match
Book1
C
1535
Sheet2
Cell Formulas
RangeFormula
C15C15=INDEX(Sheet1!\$B\$6:\$B\$55,MATCH(TODAY(),Sheet1!\$A\$6:\$A\$55,0))

Book1
AB
5
615/08/202016
716/08/202017
817/08/202018
918/08/202019
1019/08/202020
1120/08/202021
1221/08/202022
1322/08/202023
1423/08/202024
1524/08/202025
1625/08/202026
1726/08/202027
1827/08/202028
1928/08/202029
2029/08/202030
2130/08/202031
2231/08/202032
2301/09/202033
2402/09/202034
2503/09/202035
Sheet1

#### Muthukrishnan V

##### Board Regular
Works fine. Thank you Mr Mark858 sir,

You're welcome

Replies
15
Views
291
Replies
2
Views
135
Replies
5
Views
50
Replies
0
Views
161
Replies
6
Views
236