Find result based off multiple criteria including date

[klynne75]

I'm trying to find a formula that will return the customer name based off the date of deposit and amount paid. I've tried several, the latest attempt is
=INDEX('WF Depository'!H:H,AGGREGATE(15,6,ROW('WF Depository'!H:H)/(('WF Depository'!E:E=A1)*('WF Depository'!F:F=J17)),1))
I am working in Excel 365.
I have a tab (WF Depository) from the bank (duplicate amounts possible) & a daily tab (mmmdd) downloaded from my accounting system. I'd like column U on the daily tab to pull the customer name from the Depository tab based on a match to the date in cell A1 of the daily tab and a matching amount.

​	TAB: WF Depository​	​			Tab: Jun 23​
Column E	Column F	Column H		Cell A1 = 06/23/2022
Dep Date	Pymt	Company			Column J	Column U
06/23/2022	$10,342.59	MARIGOLD			$ uploaded	Company
06/23/2022	$810.87	Sierra			$810.87
06/23/2022	$1,863.75	WATER SERVICE			$1,863.75
06/23/2022	$14,294.11	GLANBIA			$10,342.59
06/23/2022	$416,609.61	CHAMPIONX			$14,294.11
06/23/2022	$200,303.04	AD CHEMCO			$57,524.43
06/23/2022	$78,243.70	Western			$78,243.70
06/23/2022	$57,524.43	SIKA CANADA			$200,303.04
					$416,609.61

 

[klynne75]

Got the answer! Totally off base with my original formula.

I found the formula below to work...
[{=IFERROR(INDEX('WF Depository'!$H:$H,MATCH(1,INDEX(($A$1='WF Depository'!$E:$E)*(J17='WF Depository'!$F:$F),0,1),0)),"NOT FOUND")}]