Spreadsheet: 870592d1717078477-formula-to-lookup-a-company-name-but-ignore-certain-id-numbers-in-a-lookup-examplea-aligw
Sheet: Sheet1

id | Cluster | company1 | company2 | company3 | company4 | company5 | company6 | company7
30017 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  | so I need to have these as blank so they are not included in any totals. in the example, [NAME] should be blank as it has the ID 30046 on Column A, this ID number is also in the lookup table.
30046 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  |  | The ID number is something along the lines of a project ID and I don't want to include this in totals so, i want it to return a blank result .
 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | 0 | 2 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 2 | 0 | 0 | 0 | 0 | 0
30759 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
30017 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
40200 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
40805 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
40387 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
50046 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
40875 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
30017 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
50049 |  | 0 | 0 | 2 | 0 | 0 | 0 | 0
40445 |  | 0 | 0 | 2 | 0 | 0 | 0 | 0
50801 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
60088 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
50753 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
50097 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
50692 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
60417 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
30017 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
60726 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
60643 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
50381 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
60365 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
60866 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
60064 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
60563 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
70186 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
30017 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
60584 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
60910 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
70757 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
70884 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
70333 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
50484 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
70994 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
70085 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
70702 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
71129 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
70334 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
70334 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
70334 |  | 0 | 0 | 0 | 0 | 3 | 0 | 0
80523 |  | 0 | 0 | 0 | 0 | 3 | 0 | 0
80433 |  | 0 | 0 | 0 | 0 | 3 | 0 | 0
70743 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
80509 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
80367 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
80149 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
80307 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
80315 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
80540 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
81110 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
80453 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
80667 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
80699 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
90206 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
80730 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
90426 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
81124 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
90064 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
80433 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
90293 |  | 0 | 0 | 0 | 0 | 4 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 4 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 4 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 4 | 0 | 0
90422 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
91072 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
91072 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
100117 |  | 0 | 0 | 4 | 0 | 0 | 0 | 0
90554 |  | 0 | 0 | 4 | 0 | 0 | 0 | 0
40631 |  | 0 | 0 | 4 | 0 | 0 | 0 | 0
40632 |  | 0 | 0 | 4 | 0 | 0 | 0 | 0
40604 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
100193 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
100442 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
91059 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
70764 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0
100345 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
100261 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
100094 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
100336 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
100612 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
100719 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
101025 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0
101025 |  | 0 | 2 | 0 | 0 | 0 | 0 | 0
100693 |  | 0 | 2 | 0 | 0 | 0 | 0 | 0
115059 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
100823 |  | 0 | 0 | 0 | 2 | 0 | 0 | 0
80327 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
105340 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
105313 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0
115195 |  | 0 | 0 | 0 | 0 | 0 | 2 | 0
115157 |  | 0 | 0 | 0 | 0 | 0 | 2 | 0
100522 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0
100455 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0