Spreadsheet: 36748d1234671641-using-2-variables-to-return-multiple-items-from-multiple-sheets-2-variables-no-array
Sheet: Data

Store_Num | Product | Location | Days_Supply | Units_in_Whse |  |  | 4 |  |  | This is here to keep it out of the formulas on the [NAME] page.
1 | A | East St | 95.51384840090363 | 4 |  |  | no |  |  | It's already working very hard, this is one thing that doesn't need
1 | B | East St | 99.76206735334321 | 8 |  |  | no |  |  | to be repeated over and over again when it can be calculated once
1 | C | East St | 9.687511276272254 | 2 |  |  | no |  |  | and refered to.
1 | D | East St | 62.56415892234213 | 8 |  |  | no
1 | E | East St | 44.98447075782575 | 8 |  |  | no |  |  | The green cell has been named "ProdCount"
1 | F | East St | 35.8070950761072 | 0 |  |  | no
1 | G | East St | 69.8758866469253 | 95 |  |  | no |  |  | These yellow helper cells can be hidden, but make the plumbing on the Summary
1 | H | East St | 39.55751280672537 | 4 |  |  | no |  |  | sheet much less intense.
1 | I | East St | 9.471635562578395 | 4 |  |  | no
1 | J | East St | 79.30068747207075 | 4 |  |  | no |  |  | I manualy changed the blue cells to show how the "OK" answers can respond, too
1 | K | East St | 82.20544501953707 | 0 |  |  | no
2 | A | 6th Ave | 74.03148261340374 | 3 |  |  | no
2 | B | 6th Ave | 82.32310541869137 | 4 |  |  | no
2 | C | 6th Ave | 77.8085108691669 | 6 |  |  | no
2 | D | 6th Ave | 13.04445215436285 | 2 |  |  | no
2 | E | 6th Ave | 183.787513786173 | 72 |  |  | no
2 | F | 6th Ave | 36.84398740696793 | 7 |  |  | no
2 | G | 6th Ave | 14.58142501880557 | 6 |  |  | 2:G
2 | H | 6th Ave | 81.55376891369829 | 1 |  |  | no
2 | I | 6th Ave | 5.711553037364059 | 2 |  |  | no
2 | J | 6th Ave | 79.50528526896544 | 10 |  |  | no
2 | K | 6th Ave | 64.70922644993426 | 9 |  |  | no
3 | A | Stafford | 91.79744092757333 | 1 |  |  | no
3 | B | Stafford | 57.15853658853727 | 4 |  |  | no
3 | C | Stafford | 18.62215750926151 | 2 |  |  | no
3 | D | Stafford | 64.63575453176924 | 3 |  |  | no
3 | E | Stafford | 35.5198975762683 | 1 |  |  | no
3 | F | Stafford | 10.69370555274691 | 4 |  |  | no
3 | G | Stafford | 11.91435650361798 | 7 |  |  | 3:G
3 | H | Stafford | 79.51639836822689 | 2 |  |  | no
3 | I | Stafford | 96.25934201340183 | 9 |  |  | no
3 | J | Stafford | 50.51121632277651 | 3 |  |  | no
3 | K | Stafford | 14.65586663162526 | 5 |  |  | no
4 | A | Manhattan | 99.01501066259073 | 2 |  |  | no
4 | B | Manhattan | 29.32478514605501 | 0 |  |  | no
4 | C | Manhattan | 42.88401888993578 | 2 |  |  | no
4 | D | Manhattan | 49.87831712599626 | 9 |  |  | no
4 | E | Manhattan | 6.071704090158025 | 1 |  |  | no
4 | F | Manhattan | 70.47553881459834 | 1 |  |  | no
4 | G | Manhattan | 20.78042457238807 | 1 |  |  | 4:G
4 | H | Manhattan | 52.3076432188021 | 7 |  |  | no
4 | I | Manhattan | 15.40665073259078 | 8 |  |  | no
4 | J | Manhattan | 52.2301024303036 | 5 |  |  | no
4 | K | Manhattan | 99.30839863197333 | 7 |  |  | no
5 | A | Ridgewood | 99.30306082649105 | 7 |  |  | no
5 | B | Ridgewood | 67.86654143376228 | 5 |  |  | no
5 | C | Ridgewood | 83.76736962029719 | 8 |  |  | no
5 | D | Ridgewood | 41.90083117434358 | 4 |  |  | no
5 | E | Ridgewood | 37.42606033349607 | 9 |  |  | no
5 | F | Ridgewood | 66.10016094601308 | 6 |  |  | no
5 | G | Ridgewood | 43.60657644043524 | 1 |  |  | 5:G
5 | H | Ridgewood | 78.4805439919761 | 6 |  |  | no
5 | I | Ridgewood | 8.105258143444939 | 3 |  |  | no
5 | J | Ridgewood | 84.0234090696776 | 5 |  |  | no
5 | K | Ridgewood | 90.58885846626836 | 4 |  |  | no