Spreadsheet: 36779d1234722680-using-2-variables-to-return-multiple-items-from-multiple-sheets-2-variables-no-array
Sheet: Summary

 | Product | D | Select from Drop Down |  |  |  |  | (delete these comments)
 | Supply Less Than | 10 |  |  |  |  |  | this version has a macro running on the sheet
 |  |  |  |  |  |  |  | that activates an autofilter to hide all the rows
 | Store | Store  Location | Supply | Available in Whse |  |  |  | that have a value of "OK" in column D. It happens
 | 1 | East St | 62.56415892234213 | 8 |  |  |  | every time you change something.
 | 2 | 6th Ave | 13.04445215436285 | 2
 | 3 | Stafford | 64.63575453176924 | 3
 | 4 | Manhattan | 49.87831712599626 | 9
 | 5 | Ridgewood | 41.90083117434358 | 4
 | 6 | Location6 | OK | More than 10
 | 7 | [NAME] | OK | More than 10
 | 8 | Location8 | OK | More than 10
 | 9 | Location9 | OK | More than 10
 | 10 | Location10 | OK | More than 10
 | 11 | Location11 | OK | More than 10
 | 12 | Location12 | OK | More than 10
 | 13 | Location13 | OK | More than 10
 | 14 | Location14 | OK | More than 10
 | 15 | Location15 | OK | More than 10
 | 16 | Location16 | OK | More than 10
 | 17 | Location17 | OK | More than 10
 | 18 | Location18 | OK | More than 10
 | 19 | Location19 | OK | More than 10
 | 20 | Location20 | OK | More than 10
 | 21 | Location21 | OK | More than 10
 | 22 | [NAME] | OK | More than 10
 | 23 | Location23 | OK | More than 10
 | 24 | Location24 | OK | More than 10
 | 25 | Location25 | OK | More than 10
 | 26 | Location26 | OK | More than 10
 | 27 | Location27 | OK | More than 10
 | 28 | Location28 | OK | More than 10
 | 29 | Location29 | OK | More than 10
 | 30 | Location30 | OK | More than 10
 | 31 | Location31 | OK | More than 10
 | 32 | Location32 | OK | More than 10
 | 33 | Location33 | OK | More than 10
 | 34 | Location34 | OK | More than 10
 | 35 | Location35 | OK | More than 10
 | 36 | Location36 | OK | More than 10
 | 37 | Location37 | OK | More than 10
 | 38 | Location38 | OK | More than 10
 | 39 | Location39 | OK | More than 10
 | 40 | Location40 | OK | More than 10
 | 41 | Location41 | OK | More than 10
 | 42 | Location42 | OK | More than 10
 | 43 | Location43 | OK | More than 10
 | 44 | Location44 | OK | More than 10
 | 45 | Location45 | OK | More than 10
 | 46 | Location46 | OK | More than 10
 | 47 | Location47 | OK | More than 10
 | 48 | [NAME] | OK | More than 10
 | 49 | Location49 | OK | More than 10
 | 50 | Location50 | OK | More than 10
 | 51 | Location51 | OK | More than 10
 | 52 | Location52 | OK | More than 10
 | 53 | Location53 | OK | More than 10
 | 54 | Location54 | OK | More than 10
 | 55 | Location55 | OK | More than 10
 | 56 | Location56 | OK | More than 10
 | 57 | Location57 | OK | More than 10
 | 58 | Location58 | OK | More than 10
 | 59 | Location59 | OK | More than 10
 | 60 | Location60 | OK | More than 10
 | 61 | Location61 | OK | More than 10
 | 62 | Location62 | OK | More than 10
 | 63 | Location63 | OK | More than 10
 | 64 | Location64 | OK | More than 10
 | 65 | Location65 | OK | More than 10
 | 66 | Location66 | OK | More than 10
 | 67 | Location67 | OK | More than 10
 | 68 | Location68 | OK | More than 10
 | 69 | [NAME] | OK | More than 10
 | 70 | Location70 | OK | More than 10
 | 71 | Location71 | OK | More than 10
 | 72 | Location72 | OK | More than 10
 | 73 | Location73 | OK | More than 10
 | 74 | Location74 | OK | More than 10
 | 75 | Location75 | OK | More than 10
 | 76 | Location76 | OK | More than 10
 | 77 | Location77 | OK | More than 10
 | 78 | Location78 | OK | More than 10
 | 79 | Location79 | OK | More than 10
 | 80 | Location80 | OK | More than 10
 | 81 | Location81 | OK | More than 10
 | 82 | Location82 | OK | More than 10
 | 83 | Location83 | OK | More than 10
 | 84 | Location84 | OK | More than 10
 | 85 | Location85 | OK | More than 10
 | 86 | Location86 | OK | More than 10
 | 87 | Location87 | OK | More than 10
 | 88 | [NAME] | OK | More than 10
 | 89 | Location89 | OK | More than 10
 | 90 | Location90 | OK | More than 10
 | 91 | Location91 | OK | More than 10
 | 92 | Location92 | OK | More than 10
 | 93 | Location93 | OK | More than 10
 | 94 | Location94 | OK | More than 10
 | 95 | Location95 | OK | More than 10
 | 96 | Location96 | OK | More than 10
 | 97 | Location97 | OK | More than 10
 | 98 | Location98 | OK | More than 10
 | 99 | Location99 | OK | More than 10
 | 100 | Location100 | OK | More than 10
 | 101 | Location101 | OK | More than 10
 | 102 | Location102 | OK | More than 10
 | 103 | Location103 | OK | More than 10
 | 104 | Location104 | OK | More than 10
 | 105 | Location105 | OK | More than 10
 | 106 | Location106 | OK | More than 10
 | 107 | Location107 | OK | More than 10
 | 108 | Location108 | OK | More than 10
 | 109 | Location109 | OK | More than 10
 | 110 | Location110 | OK | More than 10
 | 111 | Location111 | OK | More than 10
 | 112 | Location112 | OK | More than 10
 | 113 | Location113 | OK | More than 10
 | 114 | Location114 | OK | More than 10
 | 115 | Location115 | OK | More than 10
 | 116 | Location116 | OK | More than 10
 | 117 | Location117 | OK | More than 10
 | 118 | Location118 | OK | More than 10
 | 119 | Location119 | OK | More than 10
 | 120 | Location120 | OK | More than 10
 | 121 | Location121 | OK | More than 10
 | 122 | Location122 | OK | More than 10
 | 123 | Location123 | OK | More than 10
 | 124 | Location124 | OK | More than 10
 | 125 | Location125 | OK | More than 10
 | 126 | Location126 | OK | More than 10
 | 127 | Location127 | OK | More than 10
 | 128 | [NAME] | OK | More than 10
 | 129 | Location129 | OK | More than 10
 | 130 | Location130 | OK | More than 10
 | 131 | [NAME] | OK | More than 10
 | 132 | Location132 | OK | More than 10
 | 133 | Location133 | OK | More than 10
 | 134 | Location134 | OK | More than 10
 | 135 | Location135 | OK | More than 10
 | 136 | Location136 | OK | More than 10
 | 137 | Location137 | OK | More than 10
 | 138 | [NAME] | OK | More than 10
 | 139 | Location139 | OK | More than 10
 | 140 | Location140 | OK | More than 10
 | 141 | Location141 | OK | More than 10
 | 142 | Location142 | OK | More than 10
 | 143 | Location143 | OK | More than 10
 | 144 | Location144 | OK | More than 10
 | 145 | Location145 | OK | More than 10
 | 146 | Location146 | OK | More than 10
 | 147 | Location147 | OK | More than 10
 | 148 | Location148 | OK | More than 10
 | 149 | [NAME] | OK | More than 10
 | 150 | Location150 | OK | More than 10
 | 151 | [NAME] | OK | More than 10
 | 152 | Location152 | OK | More than 10
 | 153 | Location153 | OK | More than 10
 | 154 | Location154 | OK | More than 10
 | 155 | Location155 | OK | More than 10
 | 156 | Location156 | OK | More than 10
 | 157 | Location157 | OK | More than 10
 | 158 | Location158 | OK | More than 10
 | 159 | Location159 | OK | More than 10
 | 160 | Location160 | OK | More than 10
 | 161 | Location161 | OK | More than 10
 | 162 | Location162 | OK | More than 10
 | 163 | [NAME] | OK | More than 10
 | 164 | Location164 | OK | More than 10
 | 165 | Location165 | OK | More than 10
 | 166 | Location166 | OK | More than 10
 | 167 | Location167 | OK | More than 10
 | 168 | Location168 | OK | More than 10
 | 169 | Location169 | OK | More than 10
 | 170 | Location170 | OK | More than 10
 | 171 | Location171 | OK | More than 10
 | 172 | Location172 | OK | More than 10
 | 173 | Location173 | OK | More than 10
 | 174 | Location174 | OK | More than 10
 | 175 | Location175 | OK | More than 10
 | 176 | Location176 | OK | More than 10
 | 177 | Location177 | OK | More than 10
 | 178 | Location178 | OK | More than 10
 | 179 | Location179 | OK | More than 10
 | 180 | Location180 | OK | More than 10
 | 181 | Location181 | OK | More than 10
 | 182 | Location182 | OK | More than 10
 | 183 | Location183 | OK | More than 10
 | 184 | Location184 | OK | More than 10
 | 185 | Location185 | OK | More than 10
 | 186 | [NAME] | OK | More than 10
 | 187 | Location187 | OK | More than 10
 | 188 | [NAME] | OK | More than 10
 | 189 | Location189 | OK | More than 10
 | 190 | Location190 | OK | More than 10
 | 191 | Location191 | OK | More than 10
 | 192 | Location192 | OK | More than 10
 | 193 | Location193 | OK | More than 10
 | 194 | Location194 | OK | More than 10
 | 195 | Location195 | OK | More than 10
 | 196 | Location196 | OK | More than 10
 | 197 | Location197 | OK | More than 10
 | 198 | Location198 | OK | More than 10
 | 199 | Location199 | OK | More than 10
 | 200 | Location200 | OK | More than 10
 | 201 | Location201 | OK | More than 10
 | 202 | Location202 | OK | More than 10
 | 203 | Location203 | OK | More than 10
 | 204 | Location204 | OK | More than 10
 | 205 | Location205 | OK | More than 10
 | 206 | Location206 | OK | More than 10
 | 207 | Location207 | OK | More than 10
 | 208 | Location208 | OK | More than 10
 | 209 | Location209 | OK | More than 10
 | 210 | Location210 | OK | More than 10
 | 211 | Location211 | OK | More than 10
 | 212 | Location212 | OK | More than 10
 | 213 | Location213 | OK | More than 10
 | 214 | Location214 | OK | More than 10
 | 215 | Location215 | OK | More than 10
 | 216 | Location216 | OK | More than 10
 | 217 | Location217 | OK | More than 10
 | 218 | Location218 | OK | More than 10
 | 219 | Location219 | OK | More than 10
 | 220 | Location220 | OK | More than 10
 | 221 | Location221 | OK | More than 10
 | 222 | Location222 | OK | More than 10
 | 223 | Location223 | OK | More than 10
 | 224 | Location224 | OK | More than 10
 | 225 | Location225 | OK | More than 10
 | 226 | Location226 | OK | More than 10
 | 227 | Location227 | OK | More than 10
 | 228 | Location228 | OK | More than 10
 | 229 | Location229 | OK | More than 10
 | 230 | Location230 | OK | More than 10
 | 231 | Location231 | OK | More than 10
 | 232 | Location232 | OK | More than 10
 | 233 | Location233 | OK | More than 10
 | 234 | Location234 | OK | More than 10
 | 235 | Location235 | OK | More than 10
 | 236 | Location236 | OK | More than 10
 | 237 | Location237 | OK | More than 10
 | 238 | Location238 | OK | More than 10
 | 239 | Location239 | OK | More than 10
 | 240 | Location240 | OK | More than 10
 | 241 | Location241 | OK | More than 10
 | 242 | Location242 | OK | More than 10
 | 243 | Location243 | OK | More than 10
 | 244 | [NAME] | OK | More than 10
 | 245 | Location245 | OK | More than 10
 | 246 | Location246 | OK | More than 10
 | 247 | Location247 | OK | More than 10
 | 248 | Location248 | OK | More than 10
 | 249 | Location249 | OK | More than 10
 | 250 | Location250 | OK | More than 10
 | 251 | Location251 | OK | More than 10
 | 252 | Location252 | OK | More than 10
 | 253 | Location253 | OK | More than 10
 | 254 | Location254 | OK | More than 10
 | 255 | Location255 | OK | More than 10
 | 256 | Location256 | OK | More than 10
 | 257 | Location257 | OK | More than 10
 | 258 | Location258 | OK | More than 10
 | 259 | Location259 | OK | More than 10
 | 260 | Location260 | OK | More than 10
 | 261 | Location261 | OK | More than 10
 | 262 | Location262 | OK | More than 10
 | 263 | Location263 | OK | More than 10
 | 264 | Location264 | OK | More than 10
 | 265 | Location265 | OK | More than 10
 | 266 | Location266 | OK | More than 10
 | 267 | Location267 | OK | More than 10
 | 268 | Location268 | OK | More than 10
 | 269 | Location269 | OK | More than 10
 | 270 | Location270 | OK | More than 10
 | 271 | Location271 | OK | More than 10
 | 272 | [NAME] | OK | More than 10
 | 273 | Location273 | OK | More than 10
 | 274 | Location274 | OK | More than 10
 | 275 | Location275 | OK | More than 10
 | 276 | Location276 | OK | More than 10
 | 277 | Location277 | OK | More than 10
 | 278 | Location278 | OK | More than 10
 | 279 | Location279 | OK | More than 10
 | 280 | Location280 | OK | More than 10
 | 281 | Location281 | OK | More than 10
 | 282 | Location282 | OK | More than 10
 | 283 | Location283 | OK | More than 10
 | 284 | Location284 | OK | More than 10
 | 285 | Location285 | OK | More than 10
 | 286 | Location286 | OK | More than 10
 | 287 | Location287 | OK | More than 10
 | 288 | Location288 | OK | More than 10
 | 289 | Location289 | OK | More than 10
 | 290 | Location290 | OK | More than 10
 | 291 | Location291 | OK | More than 10
 | 292 | Location292 | OK | More than 10
 | 293 | Location293 | OK | More than 10
 | 294 | Location294 | OK | More than 10
 | 295 | Location295 | OK | More than 10
 | 296 | Location296 | OK | More than 10
 | 297 | Location297 | OK | More than 10
 | 298 | Location298 | OK | More than 10
 | 299 | Location299 | OK | More than 10
 | 300 | Location300 | OK | More than 10
 | 301 | Location301 | OK | More than 10
 | 302 | Location302 | OK | More than 10
 | 303 | Location303 | OK | More than 10
 | 304 | Location304 | OK | More than 10
 | 305 | Location305 | OK | More than 10
 | 306 | Location306 | OK | More than 10
 | 307 | Location307 | OK | More than 10
 | 308 | Location308 | OK | More than 10
 | 309 | Location309 | OK | More than 10
 | 310 | Location310 | OK | More than 10
 | 311 | Location311 | OK | More than 10
 | 312 | Location312 | OK | More than 10
 | 313 | Location313 | OK | More than 10
 | 314 | Location314 | OK | More than 10
 | 315 | Location315 | OK | More than 10
 | 316 | Location316 | OK | More than 10
 | 317 | Location317 | OK | More than 10
 | 318 | Location318 | OK | More than 10
 | 319 | Location319 | OK | More than 10
 | 320 | Location320 | OK | More than 10
 | 321 | Location321 | OK | More than 10
 | 322 | Location322 | OK | More than 10
 | 323 | Location323 | OK | More than 10
 | 324 | [NAME] | OK | More than 10
 | 325 | [NAME] | OK | More than 10
 | 326 | Location326 | OK | More than 10
 | 327 | Location327 | OK | More than 10
 | 328 | Location328 | OK | More than 10
 | 329 | Location329 | OK | More than 10
 | 330 | Location330 | OK | More than 10
 | 331 | Location331 | OK | More than 10
 | 332 | Location332 | OK | More than 10
 | 333 | Location333 | OK | More than 10
 | 334 | Location334 | OK | More than 10
 | 335 | Location335 | OK | More than 10
 | 336 | Location336 | OK | More than 10
 | 337 | Location337 | OK | More than 10
 | 338 | Location338 | OK | More than 10
 | 339 | Location339 | OK | More than 10
 | 340 | Location340 | OK | More than 10
 | 341 | Location341 | OK | More than 10
 | 342 | Location342 | OK | More than 10
 | 343 | Location343 | OK | More than 10
 | 344 | Location344 | OK | More than 10
 | 345 | Location345 | OK | More than 10
 | 346 | Location346 | OK | More than 10
 | 347 | Location347 | OK | More than 10
 | 348 | Location348 | OK | More than 10
 | 349 | Location349 | OK | More than 10
 | 350 | Location350 | OK | More than 10