Spreadsheet: 81377d1281585744-indexing-multiple-tables-multiple-index-question
Sheet: Sheet1

 |  |  |  |  | TERM/QTY | 3YR, 1000-3000
Product | State | Price | Promo |  |  |  |  | Product | A | 2YR, 10-49 | 2YR, 50-499 | 2YR, 500-999 | 2YR, 1000-3000 | 3YR, 10-49 | 3YR, 50-499 | 3YR, 500-999 | 3YR, 1000-3000
A | AZ | 5.84 | 20.99 |  |  |  |  |  | AZ | 25.99 | 24.99 | 23.99 | 22.99 | 23.99 | 22.99 | 21.99 | 20.99
B | CO | 30 | 21.99 |  |  |  |  |  | CO | 25.99 | 24.99 | 23.99 | 22.99 | 23.99 | 22.99 | 21.99 | 20.99
C | IA | 5.84 | 22.99 |  |  |  |  |  | IA | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
D | ID | 30 | 23.99 |  |  |  |  |  | ID | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
E | MN | 5.84 | 24.99 |  |  |  |  |  | MN | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
F | MT | 0 | #N/A |  |  |  |  |  | MT | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
G | ND | 65 | #N/A |  |  |  |  |  | ND | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
H | NE | 0 | #N/A |  |  |  |  |  | NE | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
I | NM | 0 | #N/A |  |  |  |  |  | NM | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
J | OR | 29 | #N/A |  |  |  |  |  | OR | 25.99 | 24.99 | 23.99 | 22.99 | 23.99 | 22.99 | 21.99 | 20.99
A | SD | 5.84 | 21.99 |  |  |  |  |  | SD | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
B | UT | 0 | 17.99 |  |  |  |  |  | UT | 25.99 | 24.99 | 23.99 | 22.99 | 23.99 | 22.99 | 21.99 | 20.99
C | WA | 29 | 22.99 |  |  |  |  |  | WA | 25.99 | 24.99 | 23.99 | 22.99 | 23.99 | 22.99 | 21.99 | 20.99
D | WY | 5.84 | 23.99 |  |  |  |  |  | WY | 22.99 | 21.99 | 20.99 | 19.99 | 21.99 | 20.99 | 19.99 | 18.99
E | AZ | 0 | 24.99
F | CO | 29 | #N/A
G | IA | 5.84 | #N/A |  |  |  |  | Product | B | 2YR, 10-49 | 2YR, 50-499 | 2YR, 500-999 | 2YR, 1000-3000 | 3YR, 10-49 | 3YR, 50-499 | 3YR, 500-999 | 3YR, 1000-3000
H | ID | 0 | #N/A |  |  |  |  |  | AZ | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
I | MN | 29 | #N/A |  |  |  |  |  | CO | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
J | MT | 5.84 | #N/A |  |  |  |  |  | IA | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
A | ND | 0 | 21.99 |  |  |  |  |  | ID | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
B | NE | 0.5 | 21.99 |  |  |  |  |  | MN | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
C | NM | 29 | 22.99 |  |  |  |  |  | MT | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
D | OR | 5.84 | 23.99 |  |  |  |  |  | ND | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
E | SD | 0 | 24.99 |  |  |  |  |  | NE | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
F | UT | 0.5 | #N/A |  |  |  |  |  | NM | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
G | WA | 29 | #N/A |  |  |  |  |  | OR | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
H | WY | 5.84 | #N/A |  |  |  |  |  | SD | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
I | AZ | 0 | #N/A |  |  |  |  |  | UT | 21.99 | 20.99 | 19.99 | 18.99 | 20.99 | 19.99 | 18.99 | 17.99
J | CO | 0.5 | #N/A |  |  |  |  |  | WA | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
A | IA | 29 | 21.99 |  |  |  |  |  | WY | 26.99 | 25.99 | 24.99 | 23.99 | 24.99 | 23.99 | 22.99 | 21.99
B | ID | 5.84 | 21.99
C | MN | 0 | 22.99 |  |  |  |  | Product | C | 2YR, 10-49 | 2YR, 50-499 | 2YR, 500-999 | 2YR, 1000-3000 | 3YR, 10-49 | 3YR, 50-499 | 3YR, 500-999 | 3YR, 1000-3000
D | MT | 0.5 | 23.99 |  |  |  |  |  | AZ | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
E | ND | 29 | 24.99 |  |  |  |  |  | CO | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
F | NE | 5.84 | #N/A |  |  |  |  |  | IA | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
G | NM | 0 | #N/A |  |  |  |  |  | ID | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
H | OR | 0.5 | #N/A |  |  |  |  |  | MN | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
I | SD | 29 | #N/A |  |  |  |  |  | MT | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
J | UT | 5.84 | #N/A |  |  |  |  |  | ND | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
A | WA | 0 | 20.99 |  |  |  |  |  | NE | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
B | WY | 0.5 | 21.99 |  |  |  |  |  | NM | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
C | AZ | 29 | 22.99 |  |  |  |  |  | OR | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
D | CO | 5.84 | 23.99 |  |  |  |  |  | SD | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
E | IA | 0 | 24.99 |  |  |  |  |  | UT | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
F | ID | 29 | #N/A |  |  |  |  |  | WA | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
G | MN | 5.84 | #N/A |  |  |  |  |  | WY | 28.99 | 27.99 | 26.99 | 25.99 | 25.99 | 24.99 | 23.99 | 22.99
H | MT | 0 | #N/A
I | ND | 29 | #N/A |  |  |  |  | Product | D | 2YR, 10-49 | 2YR, 50-499 | 2YR, 500-999 | 2YR, 1000-3000 | 3YR, 10-49 | 3YR, 50-499 | 3YR, 500-999 | 3YR, 1000-3000
J | NE | 5.84 | #N/A |  |  |  |  |  | AZ | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
A | NM | 0 | 21.99 |  |  |  |  |  | CO | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
B | OR | 29 | 21.99 |  |  |  |  |  | IA | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
C | SD | 5.84 | 22.99 |  |  |  |  |  | ID | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
D | UT | 0 | 23.99 |  |  |  |  |  | MN | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | MT | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | ND | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | NE | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | NM | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | OR | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | SD | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | UT | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | WA | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  |  | WY | 29.99 | 28.99 | 27.99 | 26.99 | 26.99 | 25.99 | 24.99 | 23.99
 |  |  |  |  |  |  |  | Product | E | 2YR, 10-49 | 2YR, 50-499 | 2YR, 500-999 | 2YR, 1000-3000 | 3YR, 10-49 | 3YR, 50-499 | 3YR, 500-999 | 3YR, 1000-3000
 |  |  |  |  |  |  |  |  | AZ | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | CO | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | IA | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | ID | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | MN | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | MT | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | ND | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | NE | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | NM | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | OR | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | SD | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | UT | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | WA | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99
 |  |  |  |  |  |  |  |  | WY | 30.99 | 29.99 | 28.99 | 27.99 | 27.99 | 26.99 | 25.99 | 24.99