Spreadsheet: 776163d1649538385-if-cell-a3-equals-any-value-of-another-sheet-column-retrieve-value-of-corresponding-row-testa
Sheet: REVENUES

 |  |  |  |  |  |  |  |  | [NAME] un client
DENOMINATION | CID | BILL NUMBER | BILL YEAR | BILL QUARTER | [NAME] | START | END | FIXED | RECURRING | TOTAL HTVA | TOTAL TVAC | STATUS | COMMENTS
[NAME] |  | 2022-006 |  |  |  | 2022-04-01 00:00:00 |  | 2999 |  |  |  | to receive | website creation
 |  | 2022-006 |  |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2022-006 |  |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | domain name registration
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 |  | 2022-004 |  |  |  | 2022-02-01 00:00:00 |  | 2999 |  |  |  | received | website creation
 |  | 2022-004 |  |  |  | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 |  | 2022-003 |  |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | canceled | domain name registration
 |  | 2022-002 |  |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | received | domain name registration
 |  | 2022-001 |  |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | canceled | domain name registration
 |  | 2021-007 |  |  |  | 2021-12-01 00:00:00 |  | 1599 |  |  |  | received | website creation
 |  | 2021-008 |  |  |  | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2021-008 |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2021-008 |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2021-008 |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2021-005 |  | Q4 |  | 2021-10-01 00:00:00 |  | 500 |  |  |  | received | website creation
 |  | 2021-006 |  | Q4 |  | 2021-10-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2021-003 |  | Q3 |  | 2021-07-01 00:00:00 |  |  |  |  |  | received | website creation
 |  | 2021-004 |  | Q3 |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2022-007 |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  | 2021-001 |  | Q3 |  | 2021-07-01 00:00:00 |  |  |  |  |  | received | website creation
 |  | 2021-002 |  | Q3 |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  | 2022-005 |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance