Spreadsheet: 866631d1713535256-return-value-in-1-column-based-on-last-date-match-in-another-column-help-last-date-test
Sheet: Sheet1

ACCOUNT |  |  |  |  |  | 20190003431 |  |  | 2023-09-19 00:00:00 |  |  |  |  |  | DATE
20190002231 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2019-08-06 00:00:00 | 08/06/2019
20190002231 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 11/18/2019
20190002231 |  |  |  |  |  |  |  |  |  | LFFR |  | False |  | 2020-01-20 00:00:00 | 2023-09-19 00:00:00
20190002231 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-02-04 00:00:00 | 02/04/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-05-15 00:00:00 | 05/15/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-05-11 00:00:00 | 05/15/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-05-11 00:00:00 | 05/15/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 07/30/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 08/11/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 09/09/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-09-05 00:00:00 | 09/10/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 11/23/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 12/23/2020
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-12-10 00:00:00 | 01/05/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-10-01 00:00:00 | 01/05/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 01/07/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 01/11/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 03/05/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 03/08/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 04/22/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 05/25/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 05/25/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 06/11/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 06/14/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 06/16/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2021-06-22 00:00:00 | 06/23/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2020-09-24 00:00:00 | 06/29/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2021-08-22 00:00:00 | 08/30/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2021-09-29 00:00:00 | 09/30/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 09/30/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2021-12-16 00:00:00 | 10/06/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 10/11/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2021-12-02 00:00:00 | 12/03/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 12/16/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 12/21/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 12/27/2021
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 01/06/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 01/24/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2021-06-01 00:00:00 | 01/24/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 01/25/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 02/07/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-04-20 00:00:00 | 02/07/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 02/08/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-02-07 00:00:00 | 02/09/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 02/23/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 02/24/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-04-20 00:00:00 | 04/19/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-04-22 00:00:00 | 04/27/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-07-19 00:00:00 | 05/23/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-05-21 00:00:00 | 05/23/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 07/11/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 07/19/2022
20190003431 |  |  |  |  |  |  |  |  |  | BW | BW | False |  | 2022-07-19 00:00:00 | 07/19/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-07-25 00:00:00 | 07/28/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-07-25 00:00:00 | 07/28/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2022-10-05 00:00:00 | 10/06/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 10/06/2022
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-07-16 00:00:00 | 07/17/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 07/17/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 07/18/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-07-18 00:00:00 | 07/18/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-09-19 00:00:00 | 07/18/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-08-24 00:00:00 | 07/19/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 08/22/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 09/08/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 09/14/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 09/15/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 09/18/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-09-15 00:00:00 | 09/19/2023
20190003431 |  |  |  |  |  |  |  |  |  | BW | BW | False |  | 2023-09-19 00:00:00 | 09/19/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-09-22 00:00:00 | 09/28/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2023-12-06 00:00:00 | 12/07/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 12/07/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 12/07/2023
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 03/19/2024
20190003431 |  |  |  |  |  |  |  |  |  |  |  | True |  |  | 03/19/2024
20190003431 |  |  |  |  |  |  |  |  |  |  |  | False |  | 2024-04-30 00:00:00 | 03/20/2024