Spreadsheet: 47254d1246249427-list-displaying-data-in-multiple-cells-based-on-list-selection-multiple-array
Sheet: Playa Chips

Great Prizes |  |  |  | Wonderful Prizes |  |  |  | Amazing Prizes
 | Qty Aval | Qty Used |  |  | Qty Aval | Qty Used |  |  | Qty Aval | Qty Used
350 BBS | 0 |  |  | 750 [NAME] | 0 |  |  | 1 Billion in Cash | 0
350 [NAME] | 7.2 |  |  | 1500 Recruits | 0.5 |  |  | 4500 Recruits | 0.3333333333333333
350 EXO Suits | 7.2 |  |  | 2000 Ghetto Lotto Tickets | 0.6888888888888889 |  |  | Level Up Ballas To the Next Level | 0
750 Speed Round tokens | 0 |  |  | 150 Arch Angel Liquid Metal Prototypes | 1 |  |  | Level Up Pimp To the Next Level | 0
7500 Punk Cards | 0 |  |  | 150 RPG's | 0 |  |  | Level Up Bookie To the Next Level | 0
750 Recruits | 0 |  |  | 2000 Flash Bombs | 0.2366666666666667 |  |  | Level Up Hustla To the Next Level | 0
 |  |  |  | 1500 Multi-Head Pipe Bombs | 0.125 |  |  | Level Up Sentinel To the Next Level | 0
 |  |  |  | Increase Hustla Limit for All Blocks | 0 |  |  | Level Up Killa To the Next Level | 0
 |  |  |  | Increase Bookie Limit for All Blocks | 1 |  |  | Level Up Stick-Up Kids To the Next Level | 0
 |  |  |  | Increase Pimp Limit for All Blocks | 0.6666666666666666 |  |  | Increase Worker Count on All Blocks (x2) | 0
 |  |  |  | Increase Balla Limit for All Blocks | 0
Current Chips
Level 1 Balla | 0 | Level 1 Banga | 401 | Level 1 Bookie | 480 | Level 1 Hustla | 195 | Level 1 Killa | 178 | Level 1 Pimp | 31 | Level 1 Sentinel | 105 | Level 1 SUK | 203 |  |  |  |  | _350_BBS
Level 2 Balla | 324 | Level 2 Banga | 307 | Level 2 Bookie | 594 | Level 2 Hustla | 400 | Level 2 Killa | 112 | Level 2 Pimp | 102 | Level 2 Sentinel | 167 | Level 2 SUK | 185 |  |  |  |  | _750_Grenade_Launchers
Level 3 Balla | 301 | Level 3 Banga | 3 | Level 3 Bookie | 2 | Level 3 Hustla | 490 | Level 3 Killa | 71 | Level 3 Pimp | 91 | Level 3 Sentinel | 156 | Level 3 SUK | 229 |  |  |  |  | _1_Billion_in_Cash
Level 4 Balla | 288 | Level 4 Banga | 396 | Level 4 Bookie | 147 | Level 4 Hustla | 0 | Level 4 Killa | 191 | Level 4 Pimp | 102 | Level 4 Sentinel | 140 | Level 4 SUK | 166 |  |  |  |  | _350_Grenade_Launchers
Level 5 Balla | 250 | Level 5 Banga | 0 | Level 5 Bookie | 419 | Level 5 Hustla | 154 | Level 5 Killa | 4 | Level 5 Pimp | 71 | Level 5 Sentinel | 150 | Level 5 SUK | 150 |  |  |  |  | _350_EXO_Suits
Level 6 Balla | 182 | Level 6 Banga | 208 | Level 6 Bookie | 114 | Level 6 Hustla | 235 | Level 6 Killa | 56 | Level 6 Pimp | 2 | Level 6 Sentinel | 64 | Level 6 [NAME] | 188 |  |  |  |  | _750_Speed_Round_tokens
Level 7 Balla | 0 | Level 7 Banga | 1 | Level 7 Bookie | 0 | Level 7 Hustla | 0 | Level 7 Killa | 0 | Level 7 Pimp | 0 | Level 7 Sentinel | 0 | Level 7 SUK | 0 |  |  |  |  | _7500_Punk_Cards
Level 8 Balla | 178 | Level 8 Banga | 144 | Level 8 Bookie | 144 | Level 8 Hustla | 69 | Level 8 Killa | 25 | Level 8 Pimp | 155 | Level 8 Sentinel | 1 | Level 8 SUK | 64 |  |  |  |  | _750_Recruits
Level 9 Balla | 68 | Level 9 Banga | 172 | Level 9 Bookie | 164 | Level 9 Hustla | 132 | Level 9 Killa | 41 | Level 9 Pimp | 103 | Level 9 Sentinel | 301 | Level 9 SUK | 3 |  |  |  |  | _1500_Recruits
Level 10 Balla | 299 | Level 10 Banga | 5 | Level 10 Bookie | 192 | Level 10 Hustla | 143 | Level 10 Killa | 54 | Level 10 Pimp | 126 | Level 10 Sentinel | 94 | Level 10 SUK | 294 |  |  |  |  | _2000_Ghetto_Lotto_Tickets
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _150_Arch_Angel_Liquid_Metal_Prototypes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _150_RPG's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _2000_Flash_Bombs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _1500_Multi-Head_Pipe_Bombs
_350_BBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Increase_Hustla_Limit_for_All_Blocks
Requirements | Qty | Resources | Qty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Increase_Bookie_Limit_for_All_Blocks
Level 1 Sentinel | 10 | Level 1 Sentinel | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Increase_Pimp_Limit_for_All_Blocks
Level 2 Sentinel | 10 | Level 2 Sentinel | 167 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Increase_Balla_Limit_for_All_Blocks
Level 3 Sentinel | 10 | Level 3 Sentinel | 156 | 1. I havre creted First four ranges (350 BBS to _350_Grenade_Launchers)  for you from Chip Data and you can check those ranges and you can select them from A30 List box |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _4500_Recruits
Level 1 Banga | 20 | Level 1 Banga | 401 | 2. Then selected A32:D42 then write =indirect(my_list) and press Ctrl+Shift+Enter for [NAME] formula |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Ballas_To_the_Next_Level
Level 2 Banga | 20 | Level 2 Banga | 307 | 3. I have made Ranges names / [NAME] separate work sheep which will be helpful for you to update the list as well as Ranges Names |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Pimp_To_the_Next_Level
Level 4 Banga | 20 | Level 4 Banga | 0 | 4. I always suggested to first organized data for a database purpose which is very help full for pivot table or queries. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Bookie_To_the_Next_Level
0 | 0 | 0 | 0 | Anyway, just check this file and do inform  me if any thing else you required. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Hustla_To_the_Next_Level
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Sentinel_To_the_Next_Level
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Killa_To_the_Next_Level
0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Level_Up_Stick-Up_Kids_To_the_Next_Level
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _Increase_Worker_Count_on_All_Blocks_(x2)