I am trying to create a multi factor match on the below fields. I want to create a flag/report showing if all the following fields match (Invoice, Invoice Date, Supplier, and Pay Amt). if these fields match I would like to see them in a separate report. Below is a sample data table I created for reference. The row in bold below have these fields matched.
Any help would be highly appreciated!
| Voucher | Invoice | Invoice Date | Supplier | Due Date | Entered | Pay Amt | User | Location |
| 2343 | 4231-a | 10/5/2018 | 656 | 7/1/2019 | 5/1/2018 | 5,000.00 | Jkhan | NYC |
| 9871 | 5431-1 | 5/2/2019 | 545 | 6/3/2019 | 6/1/2018 | 3,000.00 | Mali | LA |
| 3211 | 4231-a | 10/5/2018 | 656 | 12/2/2018 | 7/2/2019 | 5,000.00 | Ssmith | SF |
| 4721 | 5671-0 | 11/2/2019 | 727 | 6/1/2019 | 5/1/2018 | 3,000.00 | Jsmith | LA |
| 2311 | 4321-b | 4/2/2019 | 431 | 5/4/2018 | 6/2/2017 | 1,000.00 | Dhudson | OH |
| 7563 | 5671-0 | 5/6/2018 | 727 | 5/2/2019 | 4/12/2019 | 2,000.00 | Mrichardson | FL |
