XLOOKUP with Multiple Criteria

[dvanallen]

I need help creating an XLOOKUP formula. I want to look up and return the value in Category2 if the date, amount, and last name values in Table2 match the values in Table1. What I have isn't working. Any ideas?

Book2.xlsx
	A	B	C	D	E
1	Date	Last Name	Category	Amount
2	4/5/2023	Smith	#N/A	$31.17
3	4/25/2023	Johnson	#N/A	$103.20
4
5
6	Date2	Last Name2	Category2	Amount2
7	04/01/2023	Rodgers	Elementary	370.74
8	04/05/2023	Smith	Secondary	31.17
9	04/25/2023	Johnson	Trade School	103.20
10	04/25/2023	Johnson	University	180.00
11	04/28/2023	Smith	General	480.00
12	04/17/2023	McDonald	Medical	1,440.00
13	05/05/2023	Parker	Secnodary	31.17
14
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=XLOOKUP(1,(Table2[Last Name2]=[@[Last Name]])*(Table2[Date2]=[@Date])*(Table2[Amount2]=[@Amount]),Table2[Category2])

 

[dvanallen]

Looks like my date formatting was off. Sorry for the trouble! I've got it working now. Thx!