Spreadsheet: 769045d1645271843-look-up-matrix-lookup-matrix-example
Sheet: Sheet1

STORE ID | POSTER SPACES | POSTER NUMBER | NUMBER TO RECEIVE |  |  |  | POSTER NUMBER | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10
A | 20 | P1 |  |  |  |  | FOR HLOOKUP | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
A | 20 | P2 |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A | 20 | P3 |  |  |  |  | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A | 20 | P4 |  |  |  |  | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A | 20 | P5 |  |  |  |  | 4 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
A | 20 | P6 |  |  |  |  | 5 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
A | 20 | P7 |  |  |  |  | 6 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
A | 20 | P8 |  |  |  |  | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
A | 20 | P9 |  |  |  |  | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
A | 20 | P10 |  |  |  |  | 9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
B | 5 | P1 |  |  |  |  | 10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
B | 5 | P2 |  |  |  |  | 11 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
B | 5 | P3 |  |  |  |  | 12 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
B | 5 | P4 |  |  |  |  | 13 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1
B | 5 | P5 |  |  |  |  | 14 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1
B | 5 | P6 |  |  |  |  | 15 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
B | 5 | P7 |  |  |  |  | 16 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1
B | 5 | P8 |  |  |  |  | 17 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
B | 5 | P9 |  |  |  |  | 18 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1
B | 5 | P10 |  |  |  |  | 19 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1
C | 7 | P1 |  |  |  |  | 20 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
C | 7 | P2 |  |  |  |  | 21 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
C | 7 | P3 |  |  |  |  | 22 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
C | 7 | P4 |  |  |  |  | 23 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2
C | 7 | P5 |  |  |  |  | 24 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2
C | 7 | P6 |  |  |  |  | 25 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2
C | 7 | P7 |  |  |  |  | 26 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2
C | 7 | P8 |  |  |  |  | 27 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2
C | 7 | P9 |  |  |  |  | 28 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2
C | 12 | P10 |  |  |  |  | 29 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2
D | 12 | P1 |  |  |  |  | 30 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
D | 12 | P2 |  |  |  |  | 31 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
D | 12 | P3 |  |  |  |  | 32 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
D | 12 | P4 |  |  |  |  | 33 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3
D | 12 | P5 |  |  |  |  | 34 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3
D | 12 | P6 |  |  |  |  | 35 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3
D | 12 | P7 |  |  |  |  | 36 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3
D | 12 | P8 |  |  |  |  | 37 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3
D | 12 | P9 |  |  |  |  | 38 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3
D | 12 | P10 |  |  |  |  | 39 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3
 |  |  |  |  |  |  | 40 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 41 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 42 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 43 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 44 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 45 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 46 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 47 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4
 |  |  |  |  |  |  | 48 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4
 |  |  |  |  |  |  | 49 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4
 |  |  |  |  |  |  | 50 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5