Spreadsheet: 793227d1661359099-return-cell-values-from-a-table-based-on-multiple-criteria-example-error-details
Sheet: Audit Data

QAA | Month | [NAME] | [NAME] | [NAME] | Person | [NAME] | Attribute | Short Name | Audit Response
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 1 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 2 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 3 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 4 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 5 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 6 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 7 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 8 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 9 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 10 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 11 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 12 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 13 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 14 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 15 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 16 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 17 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 18 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 19 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 20 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 21 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 22 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 23 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 24 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 25 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 26 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 27 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 28 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 29 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 30 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Heather |  |  | Attribute 31 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 1 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 2 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 3 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 4 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 5 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 6 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 7 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 8 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 9 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 10 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 11 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 12 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 13 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 14 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 15 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 16 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 17 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 18 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 19 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 20 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 21 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 22 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 23 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 24 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 25 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 26 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 27 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 28 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 29 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 30 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Gina |  |  | Attribute 31 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 1 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 2 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 3 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 4 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 5 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 6 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 7 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 8 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 9 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 10 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 11 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 12 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 13 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 14 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 15 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 16 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 17 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 18 | Fail
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 19 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 20 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 21 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 22 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 23 | Pass
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 24 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 25 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 26 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 27 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 28 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 29 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 30 | N/A
Auditor 1 | 2022-07-01 00:00:00 |  |  |  | Manny |  |  | Attribute 31 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 1 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 2 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 3 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 4 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 5 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 6 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 7 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 8 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 9 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 10 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 11 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 12 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 13 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 14 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 15 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 16 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 17 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 18 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 19 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 20 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 21 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 22 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 23 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 24 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 25 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 26 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 27 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 28 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 29 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 30 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 31 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 1 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 2 | Fail
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 3 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 4 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 5 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 6 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 7 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 8 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 9 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 10 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 11 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 12 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 13 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 14 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 15 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 16 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 17 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 18 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 19 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 20 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 21 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 22 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 23 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 24 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 25 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 26 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 27 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 28 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 29 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 30 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | Stacy |  |  | Attribute 31 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 1 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 2 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 3 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 4 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 5 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 6 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 7 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 8 | Fail
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 9 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 10 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 11 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 12 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 13 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 14 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 15 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 16 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 17 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 18 | Fail
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 19 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 20 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 21 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 22 | Pass
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 23 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 24 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 25 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 26 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 27 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 28 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 29 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 30 | N/A
Auditor 2 | 2022-07-01 00:00:00 |  |  |  | [NAME] |  |  | Attribute 31 | N/A