Help finding value associated with date closest to (or prior to) today

[dgarciasl]

I have an excel table, containing dates in column a value in column K. I need a formula that identifies the K value associated with the today's date. if there is no value for today, it should show the value of the closest date prior today.

 

[mart37]

Are the dates sorted?

 

[mart37]

=IFERROR(INDEX($A$1:$A$100,MATCH(TODAY(),$A$1:$A$100,0)),IFERROR(INDEX($A$1:$A$100,MATCH(TODAY(),$A$1:$A$100,1)),INDEX($A$1:$A$100,MATCH(TODAY(),$A$1:$A$100,-1))))

 

[Peter_SSs]

If I have understood your requirement correctly then ...

If the dates are sorted oldest to nest, try

21 04 10.xlsm
	A										K	L	M
1	Date										Value
2	1/03/2021										7		67
3	5/03/2021										76
4	7/03/2021										83
5	13/03/2021										44
6	31/03/2021										54
7	4/04/2021										67
8	22/04/2021										96
9	28/04/2021										75
10	30/04/2021										9
Closest Date

Cell Formulas
Range	Formula
M2	M2	=VLOOKUP(TODAY(),A2:K10,11)

If the dates are not sorted, try

21 04 10.xlsm
	A										K	L	M
1	Date										Value
2	1/03/2021										7		67
3	30/04/2021										9
4	7/03/2021										83
5	13/03/2021										44
6	4/04/2021										67
7	22/04/2021										96
8	31/03/2021										54
9	5/03/2021										76
10	28/04/2021										75
Closest Date (2)

Cell Formulas
Range	Formula
M2	M2	=INDEX(K2:K10,MATCH(AGGREGATE(14,6,A2:A10/(A2:A10<=TODAY()),1),A2:A10,0))