Spreadsheet: 764193d1642629903-two-way-lookup-against-a-name-and-date-sample-data-xlookup-problem
Sheet: Potential hours

Name | [NAME] |  |  |  |  |  | Name | [NAME]
Date | 2021-01-10 00:00:00 |  |  |  |  |  | Week ending | 2021-01-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
 | Q1 |  |  |  |  |  |  |  |  |  |  |  | Q2 |  |  |  |  |  |  |  |  |  |  |  |  | Q3 |  |  |  |  |  |  |  |  |  |  |  |  | Q4
 | January |  |  |  | February |  |  |  |  |  |  |  | April |  |  |  | May |  |  |  |  | June |  |  |  | July |  |  |  | August |  |  |  |  | September |  |  |  | October |  |  |  |  | November |  |  |  | December
Name | 10/01/2021 | 17/01/2021 | 24/01/2021 | 31/01/2021 | 07/02/2021 | 14/02/2021 | 21/02/2021 | 28/02/2021 | 07/03/2021 | 14/03/2021 | 21/03/2021 | 28/03/2021 | 04/04/2021 | 11/04/2021 | 18/04/2021 | 25/04/2021 | 02/05/2021 | 09/05/2021 | 16/05/2021 | 23/05/2021 | 30/05/2021 | 06/06/2021 | 13/06/2021 | 20/06/2021 | 27/06/2021 | 04/07/2021 | 11/07/2021 | 18/07/2021 | 25/07/2021 | 01/08/2021 | 08/08/2021 | 15/08/2021 | 22/08/2021 | 29/08/2021 | 05/09/2021 | 12/09/2021 | 19/09/2021 | 26/09/2021 | 03/10/2021 | 10/10/2021 | 17/10/2021 | 24/10/2021 | 31/10/2021 | 07/11/2021 | 14/11/2021 | 21/11/2021 | 28/11/2021 | 05/12/2021
Week ending | 2021-01-10 00:00:00 | 2021-01-17 00:00:00 | 2021-01-24 00:00:00 | 2021-01-31 00:00:00 | 2021-02-07 00:00:00 | 2021-02-14 00:00:00 | 2021-02-21 00:00:00 | 2021-02-28 00:00:00 | 2021-03-07 00:00:00 | 2021-03-14 00:00:00 | 2021-03-21 00:00:00 | 2021-03-28 00:00:00 | 2021-04-04 00:00:00 | 2021-04-11 00:00:00 | 2021-04-18 00:00:00 | 2021-04-25 00:00:00 | 2021-05-02 00:00:00 | 2021-05-09 00:00:00 | 2021-05-16 00:00:00 | 2021-05-23 00:00:00 | 2021-05-30 00:00:00 | 2021-06-06 00:00:00 | 2021-06-13 00:00:00 | 2021-06-20 00:00:00 | 2021-06-27 00:00:00 | 2021-07-04 00:00:00 | 2021-07-11 00:00:00 | 2021-07-18 00:00:00 | 2021-07-25 00:00:00 | 2021-08-01 00:00:00 | 2021-08-08 00:00:00 | 2021-08-15 00:00:00 | 2021-08-22 00:00:00 | 2021-08-29 00:00:00 | 2021-09-05 00:00:00 | 2021-09-12 00:00:00 | 2021-09-19 00:00:00 | 2021-09-26 00:00:00 | 2021-10-03 00:00:00 | 2021-10-10 00:00:00 | 2021-10-17 00:00:00 | 2021-10-24 00:00:00 | 2021-10-31 00:00:00 | 2021-11-07 00:00:00 | 2021-11-14 00:00:00 | 2021-11-21 00:00:00 | 2021-11-28 00:00:00 | 2021-12-05 00:00:00
[NAME] | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 1504.000000000004
[NAME] | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 1504.000000000004
[NAME] | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 1504.000000000004
[NAME] | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 25.6 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 1504.000000000004