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]) |