Spreadsheet: 810918d1672164040-vlookup-function-with-multiple-criteria-test-dec22
Sheet: Sheet1

 | # | [NAME] | % | measure |  |  | # | [NAME] | % | [NAME] | % | [NAME] | % | [NAME] | % | [NAME] | % | [NAME] | % | measure
 | 1 | F |  |  |  |  | 1 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0 | 100
 | 2 | F |  |  |  |  | 2 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 3 | F |  |  |  |  | 3 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 4 | F |  |  |  |  | 4 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 5 | F |  |  |  |  | 5 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 6 | F |  |  |  |  | 6 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 7 | F |  |  |  |  | 7 | A | 1 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 8 | F |  |  |  |  | 8 | A | 0.9 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 9 | F |  |  |  |  | 9 | A | 0.9 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 10 | F |  |  |  |  | 10 | A | 0.9 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0
 | 11 | F |  |  |  |  | 11 | A | 0.8 | B | 1 | C | 0 | D | 0 | E | 0 | F | 0
 | 12 | F |  |  |  |  | 12 | A | 0.8 | B | 0.9 | C | 0 | D | 0 | E | 0 | F | 0
 | 13 | F |  |  |  |  | 13 | A | 0.8 | B | 0.9 | C | 0 | D | 0 | E | 0 | F | 0
 | 14 | F |  |  |  |  | 14 | A | 0.7 | B | 0.8 | C | 0 | D | 0 | E | 0 | F | 0
 | 15 | F |  |  |  |  | 15 | A | 0.7 | B | 0.8 | C | 1 | D | 0 | E | 0 | F | 0
 | 16 | F |  |  |  |  | 16 | A | 0.6 | B | 0.7 | C | 0.9 | D | 1 | E | 0 | F | 0
 | 17 | F |  |  |  |  | 17 | A | 0.5 | B | 0.7 | C | 0.8 | D | 0.9 | E | 1 | F | 0
 | 18 | F |  |  |  |  | 18 | A | 0.4 | B | 0.6 | C | 0.7 | D | 0.8 | E | 0.9 | F | 1
 | 19 | F |  |  |  |  | 19 | A | 0.3 | B | 0.5 | C | 0.6 | D | 0.7 | E | 0.8 | F | 0.9
 | 20 | F |  |  |  |  | 20 | A | 0.2 | B | 0.4 | C | 0.5 | D | 0.6 | E | 0.7 | F | 0.8
 | 21 | F |  |  |  |  | 21 | A | 0.1 | B | 0.3 | C | 0.4 | D | 0.5 | E | 0.6 | F | 0.7 | 3
 | 22 | F |  |  |  |  | 22 | A | 0.1 | B | 0.2 | C | 0.3 | D | 0.4 | E | 0.5 | F | 0.6 | 2
 | 23 | F |  |  |  |  | 23 | A | 0.1 | B | 0.1 | C | 0.2 | D | 0.3 | E | 0.4 | F | 0.5 | 1
 | 24 | F |  |  |  |  | 24 | A | 0 | B | 0 | C | 0.1 | D | 0.2 | E | 0.3 | F | 0.4 | 0
 | 25 | F |  |  |  |  | 25 | A | 0 | B | 0 | C | 0 | D | 0.1 | E | 0.2 | F | 0.3 | 0
 | 26 | F |  |  |  |  | 26 | A | 0 | B | 0 | C | 0 | D | 0 | E | 0.1 | F | 0.2 | 0
 | 27 | F |  |  |  |  | 27 | A | 0 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0.1 | 0
 | 28 | F |  |  |  |  | 28 | A | 0 | B | 0 | C | 0 | D | 0 | E | 0 | F | 0 | 0
 | 1 | E
 | 2 | E
 | 3 | E
 | 4 | E
 | 5 | E
 | 6 | E
 | 7 | E
 | 8 | E
 | 9 | E
 | 10 | E
 | 11 | E
 | 12 | E
 | 13 | E
 | 14 | E
 | 15 | E
 | 16 | E
 | 17 | E
 | 18 | E
 | 19 | E
 | 20 | E
 | 21 | E
 | 22 | E
 | 23 | E
 | 24 | E
 | 25 | E
 | 26 | E
 | 27 | E
 | 28 | E
 | 1 | D
 | 2 | D
 | 3 | D
 | 4 | D
 | 5 | D
 | 6 | D
 | 7 | D
 | 8 | D
 | 9 | D
 | 10 | D
 | 11 | D
 | 12 | D
 | 13 | D
 | 14 | D
 | 15 | D
 | 16 | D
 | 17 | D
 | 18 | D
 | 19 | D
 | 20 | D
 | 21 | D
 | 22 | D
 | 23 | D
 | 24 | D
 | 25 | D
 | 26 | D
 | 27 | D
 | 28 | D
 | 1 | C
 | 2 | C
 | 3 | C
 | 4 | C
 | 5 | C
 | 6 | C
 | 7 | C
 | 8 | C
 | 9 | C
 | 10 | C
 | 11 | C
 | 12 | C
 | 13 | C
 | 14 | C
 | 15 | C
 | 16 | C
 | 17 | C
 | 18 | C
 | 19 | C
 | 20 | C
 | 21 | C
 | 22 | C
 | 23 | C
 | 24 | C
 | 25 | C
 | 26 | C
 | 27 | C
 | 28 | C
 | 1 | B
 | 2 | B
 | 3 | B
 | 4 | B
 | 5 | B
 | 6 | B
 | 7 | B
 | 8 | B
 | 9 | B
 | 10 | B
 | 11 | B
 | 12 | B
 | 13 | B
 | 14 | B
 | 15 | B
 | 16 | B
 | 17 | B
 | 18 | B
 | 19 | B
 | 20 | B
 | 21 | B
 | 22 | B
 | 23 | B
 | 24 | B
 | 25 | B
 | 26 | B
 | 27 | B
 | 28 | B
 | 1 | A
 | 2 | A
 | 3 | A
 | 4 | A
 | 5 | A
 | 6 | A
 | 7 | A
 | 8 | A
 | 9 | A
 | 10 | A
 | 11 | A
 | 12 | A
 | 13 | A
 | 14 | A
 | 15 | A
 | 16 | A
 | 17 | A
 | 18 | A
 | 19 | A
 | 20 | A
 | 21 | A
 | 22 | A
 | 23 | A
 | 24 | A
 | 25 | A
 | 26 | A
 | 27 | A
 | 28 | A