Spreadsheet: 25111d1216228947-lookup-and-sum-example
Sheet: ANTITRUST CASES

CASE NAME | STATUS NOTES | OWNER | RATING | LEAD | FIRM | TEAM
 |  |  |  | 1 | firm1
 |  |  |  | 0 | [NAME]
 |  |  |  | 0.25 | firm44
 |  |  |  | 0.25 | firm 12
 |  |  |  | 0.25 | firm6
 |  |  |  | 0.25 | firm18
 |  |  |  | 1 | firm109
 |  |  |  | 0 | firm12
 |  |  |  | 0 | firm9
 |  |  |  | 0.5 | [NAME]
 |  |  |  | 0.5 | firm12
 |  |  |  | 1 | [NAME]
 |  |  |  | 0.33 | firm79
 |  |  |  | 0.33 | firm8
 |  |  |  | 0.34 | [NAME]
 |  |  |  | 0.5 | firm12
 |  |  |  | 0.5 | firm64
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 0.5
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.75
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 1
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 0.25
 |  |  |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0.5
 |  |  |  | 0.5
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 0.33
 |  |  |  | 0.33
 |  |  |  | 0.34
 |  |  |  | 0
 |  |  |  | 0