Populate Data According to Date

[kumara_faith]

Hi,

I have the following table:

Book2.xlsx
	B	C	D	E	F	G	H	I	J	K	L
2	Sheet 1- Actual Expense				Sheet 2- Budgeted Expense				Sheet 3- Balance Budgeted
3	Date	Expense	Amount		Date	Expense	Amount		Date	Expense	Amount
4	12/11/2023	Food	50		12/11/2023	Food	35		21/11/2023	Food	35
5	13/11/2023	Travel	50		13/11/2023	Travel	35		22/11/2023	Travel	35
6	14/11/2023	Gadgets	50		14/11/2023	Gadgets	35		23/11/2023	Gadgets	35
7	15/11/2023	Food	50		15/11/2023	Food	35		24/11/2023	Food	35
8	16/11/2023	Travel	50		16/11/2023	Travel	35		25/11/2023	Travel	35
9	17/11/2023	Gadgets	50		17/11/2023	Gadgets	35		26/11/2023	Gadgets	35
10	18/11/2023	Food	50		18/11/2023	Food	35		27/11/2023	Food	35
11	19/11/2023	Travel	50		19/11/2023	Travel	35		28/11/2023	Travel	35
12	20/11/2023	Gadgets	50		20/11/2023	Gadgets	35		29/11/2023	Gadgets	35
13					21/11/2023	Food	35		30/11/2023	Gadgets	35
14					22/11/2023	Travel	35
15					23/11/2023	Gadgets	35
16					24/11/2023	Food	35
17					25/11/2023	Travel	35
18					26/11/2023	Gadgets	35
19					27/11/2023	Food	35
20					28/11/2023	Travel	35
21					29/11/2023	Gadgets	35
22					30/11/2023	Gadgets	35
Sheet1

In Sheet 1, I have the actual expenses. In Sheet 2, I have the budgeted expenses. In Sheet 3, I would like to populate only the details from Sheet 2 after the last date of Sheet1. In this case, the last date in Sheet 1 is 20 Nov 2023. As such, the details from 21 Nov 2023 to 30 Nov 2023 from Sheet 2 should be populated in Sheet 3. Is this possible via a formula ? The correct result is shown in Sheet 3. Appreciate all the help.

 

[SanjayGMusafir]

Is this what you are looking for? Check and revert -

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2		Sheet 1- Actual Expense				Sheet 2- Budgeted Expense				Sheet 3- Balance Budgeted
3		Date	Expense	Amount		Date	Expense	Amount		Date	Expense	Amount
4		11/12/23	Food	50		11/12/23	Food	35		11/21/23	Food	35
5		11/13/23	Travel	50		11/13/23	Travel	35		11/22/23	Travel	35
6		11/14/23	Gadgets	50		11/14/23	Gadgets	35		11/23/23	Gadgets	35
7		11/15/23	Food	50		11/15/23	Food	35		11/24/23	Food	35
8		11/16/23	Travel	50		11/16/23	Travel	35		11/25/23	Travel	35
9		11/17/23	Gadgets	50		11/17/23	Gadgets	35		11/26/23	Gadgets	35
10		11/18/23	Food	50		11/18/23	Food	35		11/27/23	Food	35
11		11/19/23	Travel	50		11/19/23	Travel	35		11/28/23	Travel	35
12		11/20/23	Gadgets	50		11/20/23	Gadgets	35		11/29/23	Gadgets	35
13						11/21/23	Food	35		11/30/23	Gadgets	35
14						11/22/23	Travel	35
15						11/23/23	Gadgets	35
16						11/24/23	Food	35
17						11/25/23	Travel	35
18						11/26/23	Gadgets	35
19						11/27/23	Food	35
20						11/28/23	Travel	35
21						11/29/23	Gadgets	35
22						11/30/23	Gadgets	35
Sheet1

Cell Formulas
Range	Formula
J3:L3	J3	=F3:H3
J4:L13	J4	=LET(LDt,MAX(B4:B12),FILTER(F4:H22,F4:F22>LDt))
Dynamic array formulas.

 

[kumara_faith]

Hi Sanjay,

Thank you for your response. That worked. Appreciate your solution and have great day ahead.

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.