Return a date if on that date a value in a column becomes greater than another column.

Hi,

Thanks in advance!

I am making a excel sheet where I have costs in column A. Savings A in column B. Savings B in colunn F. Savings C in column H.

I want to return a date if on that date a the value of a Savings column is bigger than the costs.
To know which savings (A, B or C) has to be compared to the costs I have a cell with a dropdown menu.

Can someone help me with this?

I also uploaded a testfile to better explain what I want.

Problem:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	J	K	L
1	It want to have a formula that looks at which savings I select in L2 and then checks from which date that specific savings is bigger than costs
2	Select savings		Savings A
3	Date savings>costs

Sheet: Blad1

No expected result - just a blank cell. What's the expected date?

EDIT Found it!

In L3:

=TAKE(LET(f,FILTER(D3:H123,D2:H2=L2),FILTER(A3:A123,B3:B123<f)),1)

Format L3 as SHORT DATE.

Glad to have helped.

If you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.