Spreadsheet: 95569d1295163142-need-solution-to-pull-data-from-sheet1-to-sheet2-if-value-0-mafiawars_testsheet
Sheet: Sheet2

Type | Top Weapons | Attack: | Defense: | Using: | Owned: | Total: | Giftable: |  | Weapons - Attack Total |  |  | 501 |  | 35506
Weapons | Little Dog | 190 | 160 | 1 | 1 | 190 | 0 |  | Armor - Attack Total |  |  | 501 |  | 29886
Weapons | Set of Hill's Heavy Weapons | 160 | 175 | 1 | 1 | 160 | 0 |  | Vehicles - Attack Total |  |  | 501 |  | 32877
Weapons | Gun Powdered Milk | 134 | 105 | 2 | 2 | 268 | 0 |  | Animals - Attack Total |  |  | 501 |  | 29501
Weapons | Executive Decision | 130 | 102 | 1 | 1 | 130 | 5 |  |  |  | Total Defense for Mafia |  |  | 127770
Weapons | Trieste's Pistol | 129 | 104 | 1 | 1 | 129 | 0
Weapons | Power Rifle | 120 | 160 | 1 | 1 | 120 | 0
Weapons | North Pole | 110 | 93 | 1 | 1 | 110 | 0
Weapons | [NAME] | 110 | 135 | 1 | 1 | 110 | 0
Weapons | [NAME] Shotgun | 107 | 69 | 1 | 1 | 107 | 0
Weapons | 40mm Bunker Buster | 101 | 68 | 1 | 1 | 101 | 10
Weapons | [NAME] | 94 | 136 | 1 | 1 | 94 | 0
Weapons | Power Armor Claw | 91 | 49 | 1 | 1 | 91 | 0
Weapons | [NAME] | 88 | 51 | 1 | 1 | 88 | 0
Weapons | Black Irish | 84 | 59 | 4 | 4 | 336 | 0
Weapons | Silk Thunder | 84 | 59 | 1 | 1 | 84 | 0
Weapons | Sin City Shooter | 81 | 36 | 1 | 1 | 81 | 0
Weapons | Rico's Revenge | 81 | 37 | 3 | 3 | 243 | 0
Weapons | Nightmare Claw | 80 | 41 | 1 | 1 | 80 | 0
Weapons | Tiebreaker | 76 | 42 | 1 | 1 | 76 | 0
Weapons | Anesthesia | 75 | 50 | 2 | 2 | 150 | 0
Weapons | [NAME] | 75 | 39 | 2 | 2 | 150 | 0
Weapons | Hood Gun | 74 | 39 | 1 | 1 | 74 | 0
Weapons | Garrotte | 73 | 44 | 1 | 1 | 73 | 0
Weapons | 9mm Fury | 72 | 49 | 7 | 7 | 504 | 0
Weapons | Fish Spear | 72 | 45 | 1 | 1 | 72 | 0
Weapons | Del Brenta Cane Sword | 72 | 133 | 1 | 1 | 72 | 0
Weapons | Silenced Sniper Rifle | 70 | 28 | 4 | 4 | 280 | 0
Weapons | Whiplash | 69 | 29 | 7 | 7 | 483 | 0
Weapons | Z17 Micro | 69 | 45 | 23 | 23 | 1587 | 0
Weapons | New Years Resolution | 69 | 46 | 427 | 456 | 29463 | 29
Armor | Experimental Exosuit | 185 | 106 | 1 | 1 | 185 | 0
Armor | D.R.E. | 140 | 95 | 2 | 2 | 280 | 0
Armor | Bidwell's Suit | 130 | 151 | 1 | 1 | 130 | 0
Armor | Night Vision Viewer | 106 | 71 | 1 | 1 | 106 | 0
Armor | Set of Government Secrets | 103 | 132 | 1 | 1 | 103 | 0
Armor | [NAME] | 89 | 51 | 1 | 1 | 89 | 0
Armor | HALO Wingsuit | 88 | 51 | 1 | 1 | 88 | 0
Armor | Igloo Shield | 82 | 44 | 1 | 1 | 82 | 0
Armor | Orange Peel | 79 | 40 | 1 | 1 | 79 | 0
Armor | Black Friday Mask | 79 | 44 | 1 | 1 | 79 | 0
Armor | [NAME] | 79 | 47 | 2 | 2 | 158 | 0
Armor | Pair of [NAME]'s [NAME] | 76 | 125 | 1 | 1 | 76 | 0
Armor | Enzo's Monocle | 74 | 104 | 1 | 1 | 74 | 0
Armor | Ballistic Vest | 72 | 103 | 1 | 1 | 72 | 0
Armor | Infiltration Gear | 72 | 40 | 3 | 3 | 216 | 0
Armor | Orange Peel | 71 | 33 | 1 | 1 | 71 | 0
Armor | Rogue CIA Agent | 69 | 30 | 5 | 5 | 345 | 0
Armor | Hit Squad | 65 | 45 | 1 | 1 | 65 | 0
Armor | [NAME] | 63 | 31 | 77 | 77 | 4851 | 0
Armor | Gluttony | 63 | 30 | 1 | 1 | 63 | 0
Armor | [NAME] | 60 | 29 | 10 | 10 | 600 | 0
Armor | ShrapShield | 59 | 30 | 2 | 2 | 118 | 0
Armor | [NAME] | 58 | 28 | 10 | 10 | 580 | 0
Armor | [NAME]'s Mask | 58 | 40 | 1 | 1 | 58 | 0
Armor | [NAME] and [NAME] | 57 | 36 | 372 | 394 | 21204 | 22
Armor | Pantomime Horse | 57 | 31 | 2 | 2 | 114 | 0
Vehicle | [NAME]'s Motorcycle | 162 | 140 | 1 | 1 | 162 | 0
Vehicle | Auto Elettrica | 133 | 89 | 1 | 1 | 133 | 0
Vehicle | Hallorans Helicopter | 120 | 190 | 1 | 1 | 120 | 0
Vehicle | Berzerker | 120 | 60 | 4 | 4 | 480 | 0
Vehicle | Handbasket | 118 | 72 | 4 | 4 | 472 | 0
Vehicle | Outlander | 112 | 58 | 1 | 1 | 112 | 10
Vehicle | [NAME] | 110 | 59 | 1 | 1 | 110 | 0
Vehicle | [NAME] | 107 | 55 | 1 | 1 | 107 | 0
Vehicle | Oinker | 100 | 128 | 1 | 1 | 100 | 0
Vehicle | Crushed Ice | 96 | 59 | 1 | 1 | 96 | 0
Vehicle | Broadside | 90 | 42 | 1 | 1 | 90 | 0
Vehicle | [NAME] | 90 | 72 | 1 | 1 | 90 | 0
Vehicle | Black Beauty | 90 | 45 | 1 | 1 | 90 | 0
Vehicle | Go Fast Boat | 82 | 45 | 5 | 5 | 410 | 0
Vehicle | Alves' Muscle Car | 81 | 105 | 1 | 1 | 81 | 0
Vehicle | Autumn Harvester | 80 | 41 | 1 | 1 | 80 | 0
Vehicle | [NAME] | 77 | 60 | 1 | 1 | 77 | 0
Vehicle | [NAME] | 75 | 41 | 1 | 1 | 75 | 0
Vehicle | KAO Rockstar | 75 | 41 | 1 | 1 | 75 | 0
Vehicle | Lockdown | 74 | 46 | 1 | 1 | 74 | 0
Vehicle | Legacy | 70 | 47 | 9 | 9 | 630 | 0
Vehicle | Phantasm | 67 | 45 | 73 | 73 | 4891 | 0
Vehicle | [NAME] | 67 | 51 | 25 | 25 | 1675 | 0
Vehicle | Mach-4 | 66 | 48 | 1 | 1 | 66 | 0
Vehicle | Envy | 66 | 36 | 2 | 2 | 132 | 0
Vehicle | Lockdown | 66 | 40 | 1 | 1 | 66 | 0
Vehicle | Amplitude | 65 | 39 | 7 | 7 | 455 | 0
Vehicle | [NAME]'s Motorcycle | 64 | 88 | 20 | 20 | 1280 | 0
Vehicle | ET Hybrid | 63 | 75 | 2 | 2 | 126 | 0
Vehicle | [NAME] | 62 | 15 | 330 | 417 | 20460 | 87
Vehicle | [NAME] | 62 | 34 | 1 | 1 | 62 | 0
Animals | Gray [NAME] | 127 | 94 | 2 | 2 | 254 | 0
Animals | [NAME] | 115 | 109 | 1 | 1 | 115 | 0
Animals | Red Piranha | 110 | 82 | 1 | 1 | 110 | 0
Animals | Snowdrift | 83 | 38 | 1 | 1 | 83 | 0
Animals | Aldo's Palermitan Horse | 82 | 121 | 1 | 1 | 82 | 20
Animals | Chomps | 80 | 37 | 1 | 1 | 80 | 0
Animals | Wild Turkey | 79 | 65 | 1 | 1 | 79 | 0
Animals | Black Backed [NAME] | 76 | 42 | 1 | 1 | 76 | 0
Animals | [NAME] | 72 | 39 | 12 | 12 | 864 | 0
Animals | [NAME] | 72 | 99 | 2 | 2 | 144 | 15
Animals | Mud Snake | 68 | 32 | 12 | 12 | 816 | 0
Animals | Dreacht Capall | 67 | 111 | 3 | 3 | 201 | 0
Animals | Galapagos Hawk | 64 | 32 | 1 | 1 | 64 | 0
Animals | Hippopotamus | 63 | 46 | 1 | 1 | 63 | 0
Animals | Meadow Viper | 62 | 37 | 83 | 83 | 5146 | 0
Animals | Turkey Vulture | 62 | 50 | 4 | 4 | 248 | 0
Animals | Warthog | 62 | 50 | 1 | 1 | 62 | 0
Animals | Red Fox | 62 | 26 | 17 | 17 | 1054 | 0
Animals | Great White Shark | 59 | 21 | 3 | 3 | 177 | 0
Animals | Hopi Rattle Snake | 58 | 32 | 2 | 2 | 116 | 0
Animals | Rock Python | 58 | 31 | 1 | 1 | 58 | 0
Animals | Falcon | 58 | 27 | 1 | 1 | 58 | 0
Animals | African Lion | 58 | 36 | 3 | 3 | 174 | 0
Animals | Coccodrillo | 57 | 40 | 1 | 1 | 57 | 0
Animals | Snapping Turtle | 56 | 25 | 2 | 2 | 112 | 0
Animals | Diamondback | 56 | 48 | 343 | 376 | 19208 | 33