Spreadsheet: 854138d1704119213-excel-formula-for-complicated-lookup-samplefile_pullamount
Sheet: BatchList

Date | ID | Name | RD | RC | PC | EC | GA | NA | RV | TR | PV | PA | TP | Status | Eva | ED | DE | ED | FSD | LST
2021-01-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 100 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-01-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 200 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-01-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 300 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-02-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 400 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-02-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 500 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-02-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 600 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-03-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 700 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-03-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 800 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-03-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 900 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-04-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1000 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-04-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1100 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-04-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1200 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-05-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1300 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-05-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1400 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-05-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1500 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-06-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1600 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-06-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1700 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-06-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1800 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-07-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 1900 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-07-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2000 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2023-07-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2100 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-08-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2200 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-08-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2300 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2023-08-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2400 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-09-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2500 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-09-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2600 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2023-09-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2700 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-10-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2800 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2023-10-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 2900 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2021-11-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 3000 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-11-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 3100 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2023-11-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 3200 | RV | TR | PV | PA | TP | Closed by Data Entry | Eva | ED | DE | ED | FSD | LST
2021-12-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 3300 | RV | TR | PV | PA | TP | Payment Closed | Eva | ED | DE | ED | FSD | LST
2022-12-01 00:00:00 | 25000003 | Name | RD | RC | PC | EC | GA | 3400 | RV | TR | PV | PA | TP | Settled | Eva | ED | DE | ED | FSD | LST
2023-03-01 00:00:00 | 25000005 | Name | RD | RC | PC | EC | GA | 3500 | RV | TR | PV | PA | TP | Closed by Data Entry | Eva | ED | DE | ED | FSD | LST
2023-01-01 00:00:00 | 25000005 | Name | RD | RC | PC | EC | GA | 3600 | RV | TR | PV | PA | TP | Closed by Data Entry | Eva | ED | DE | ED | FSD | LST