Latest Data Pull-up from the corresponding date-Single party

[Sunil Pinto]

How can i pull the data from the corresponding date with single party

I mentioned example of date in right side 1st April my latest data is 6,675

ABC Co Ltd
Date	Advance	Bill	Balance		1 Apr 2024​	6,675
1 Feb 2024​	10,000	250	9,750		19 May 2024​	4,975
1 Feb 2024​	9,750	275	9,475		27 Oct 2024​	2,700
10 Feb 2024​	9,475	350	9,125
12 Feb 2024​	9,125	450	8,675
14 Feb 2024​	8,675	550	8,125
15 Feb 2024​	8,125	300	7,825
1 Mar 2024​	7,825	300	7,525
9 Mar 2024​	7,525	400	7,125
1 Apr 2024​	7,125	100	7,025
1 Apr 2024​	7,025	350	6,675
5 Apr 2024​	6,675	350	6,325
27 Apr 2024​	6,325	350	5,975
1 May 2024​	5,975	300	5,675
15 May 2024​	5,675	500	5,175
19 May 2024​	5,175	200	4,975
1 Jun 2024​	4,975	600	4,375
19 Jun 2024​	4,375	250	4,125
23 Jun 2024​	4,125	300	3,825
25 Jun 2024​	3,825	150	3,675
10 Jul 2024​	3,675	475	3,200
27 Oct 2024​	3,200	500	2,700

 

[Sergius]

If we take into account that the data in the table starts from the third row, column A is the date, and column D is the balance, the date for which we are looking is in cell F2, then in cell G2 we enter the following array formula

=INDEX($D$3:$D$23;MAX(IF($A$3:$A$23=$F2;ROW($D$3:$D$23)-2)))

 

[Sunil Pinto]

If we take into account that the data in the table starts from the third row, column A is the date, and column D is the balance, the date for which we are looking is in cell F2, then in cell G2 we enter the following array formula

=INDEX($D$3:$D$23;MAX(IF($A$3:$A$23=$F2;ROW($D$3:$D$23)-2)))

Can you please use this formula in excel sheet and repast the same. Your formula is not working with me. I tried many times.

 

[Sergius]

You entered it as an array formula, or as a regular one. Here's a photo of what I have