Spreadsheet: 771401d1646656082-using-vlookup-on-multiple-columns-vlookup-example
Sheet: SCORES

 | candidate | ID | SPECIAL | A | B | C | D | OUTCOME |  |  | candidate | ID | SPECIAL | A | B | C | D | OUTCOME |  |  | candidate | ID | SPECIAL | A | B | C | D | OUTCOME
 | candidate 1 | 73852 |  |  |  |  |  | 3 |  |  | candidate 21 | 82086 | Y |  |  |  |  | 3 |  |  | candidate 41 | 60954 | Y |  |  |  |  | 3
 | candidate 2 | 22401 |  |  |  |  |  | 5 |  |  | candidate 22 | 78117 | Y |  |  |  |  | 5 |  |  | candidate 42 | 10751 | Y |  |  |  |  | 5
 | candidate 3 | 18924 | Y |  |  |  |  | 6 |  |  | candidate 23 | 51902 | Y |  |  |  |  | 6 |  |  | candidate 43 | 51845 | Y |  |  |  |  | 6
 | candidate 4 | 4219 |  |  |  |  |  | 2 |  |  | candidate 24 | 75811 | Y |  |  |  |  | 2 |  |  | candidate 44 | 27683 | Y |  |  |  |  | 2
 | candidate 5 | 81370 |  |  |  |  |  | 3 |  |  | candidate 25 | 71982 | Y |  |  |  |  | 3 |  |  | candidate 45 | 68390 |  |  |  |  |  | 3
 | candidate 6 | 37401 |  |  |  |  |  |  |  |  | candidate 26 | 41201 | Y |  |  |  |  |  |  |  | candidate 46 | 86682
 | candidate 7 | 79223 | Y |  |  |  |  | 4 |  |  | candidate 27 | 95571 |  |  |  |  |  | 4 |  |  | candidate 47 | 23453 |  |  |  |  |  | 4
 | candidate 8 | 66720 |  |  |  |  |  | 6 |  |  | candidate 28 | 59111 |  |  |  |  |  | 6 |  |  | candidate 48 | 18756 | Y |  |  |  |  | 6
 | candidate 9 | 39716 | Y |  |  |  |  | 3 |  |  | candidate 29 | 19024 |  |  |  |  |  | 3 |  |  | candidate 49 | 64976 |  |  |  |  |  | 3
 | candidate 10 | 3522 |  |  |  |  |  |  |  |  | candidate 30 | 27175 | Y |  |  |  |  |  |  |  | candidate 50 | 78197 | Y
 | candidate 11 | 69182 | Y |  |  |  |  | 8 |  |  | candidate 31 | 26828 |  |  |  |  |  | 8 |  |  | candidate 51 | 68992 |  |  |  |  |  | 8
 | candidate 12 | 10314 | Y |  |  |  |  | 7 |  |  | candidate 32 | 12849 | Y |  |  |  |  | 7 |  |  | candidate 52 | 43386 |  |  |  |  |  | 7
 | candidate 13 | 83027 | Y |  |  |  |  | 2 |  |  | candidate 33 | 28696 |  |  |  |  |  | 2 |  |  | candidate 53 | 23177 |  |  |  |  |  | 2
 | candidate 14 | 94041 | Y |  |  |  |  | 9 |  |  | candidate 34 | 9049 |  |  |  |  |  | 9 |  |  | candidate 54 | 1632 |  |  |  |  |  | 9
 | candidate 15 | 98831 | Y |  |  |  |  | 2 |  |  | candidate 35 | 97541 |  |  |  |  |  | 2 |  |  | candidate 55 | 35552 |  |  |  |  |  | 2
 | candidate 16 | 6553 | Y |  |  |  |  | 7 |  |  | candidate 36 | 68826 |  |  |  |  |  | 7
 | candidate 17 | 33081 | Y |  |  |  |  | 1 |  |  | candidate 37 | 63493 | Y |  |  |  |  | 1
 | candidate 18 | 2968 |  |  |  |  |  | 3 |  |  | candidate 38 | 46280 |  |  |  |  |  | 3
 | candidate 19 | 46281 |  |  |  |  |  | 5 |  |  | candidate 39 | 38466 |  |  |  |  |  | 5
 | candidate 20 | 79396 | Y |  |  |  |  | 6 |  |  | candidate 40 | 49755 |  |  |  |  |  | 6
 | candidate | ID | SPECIAL | A | B | C | D | OUTCOME |  |  | candidate | ID | SPECIAL | A | B | C | D | OUTCOME |  |  | candidate | ID | SPECIAL | A | B | C | D | OUTCOME
 | candidate 56 | 24896 |  |  |  |  |  | 3 |  |  | candidate 75 | 73738 |  |  |  |  |  | 3 |  |  | candidate 90 | 490 |  |  |  |  |  | 3
 | candidate 57 | 27838 |  |  |  |  |  | 5 |  |  | candidate 76 | 77323 |  |  |  |  |  | 5 |  |  | candidate 91 | 57860 | Y |  |  |  |  | 5
 | candidate 58 | 82089 |  |  |  |  |  | 6 |  |  | candidate 77 | 13527 | Y |  |  |  |  | 6 |  |  | candidate 92 | 23647 |  |  |  |  |  | 6
 | candidate 59 | 70827 |  |  |  |  |  | 2 |  |  | candidate 78 | 28402 |  |  |  |  |  | 2 |  |  | candidate 93 | 37789 |  |  |  |  |  | 2
 | candidate 60 | 78414 | Y |  |  |  |  | 3 |  |  | candidate 79 | 60654 |  |  |  |  |  | 3 |  |  | candidate 94 | 42312 |  |  |  |  |  | 3
 | candidate 61 | 94781 |  |  |  |  |  |  |  |  | candidate 80 | 16071 | Y |  |  |  |  |  |  |  | candidate 95 | 4186 | Y
 | candidate 62 | 728 |  |  |  |  |  | 4 |  |  | candidate 81 | 65038 |  |  |  |  |  | 4 |  |  | candidate 96 | 79485 |  |  |  |  |  | 4
 | candidate 63 | 96215 | Y |  |  |  |  | 6 |  |  | candidate 82 | 54790 |  |  |  |  |  | 6 |  |  | candidate 97 | 70295 |  |  |  |  |  | 6
 | candidate 64 | 48945 |  |  |  |  |  | 3 |  |  | candidate 83 | 59154 |  |  |  |  |  | 3 |  |  | candidate 98 | 30729 | Y |  |  |  |  | 3
 | candidate 65 | 88466 |  |  |  |  |  |  |  |  | candidate 84 | 48435 | Y |  |  |  |  |  |  |  | candidate 99 | 59259
 | candidate 66 | 7372 |  |  |  |  |  | 8 |  |  | candidate 85 | 83357 | Y |  |  |  |  | 8
 | candidate 67 | 23510 | Y |  |  |  |  | 7 |  |  | candidate 86 | 18741 |  |  |  |  |  | 7
 | candidate 68 | 27844 |  |  |  |  |  | 2 |  |  | candidate 87 | 15296 |  |  |  |  |  | 2
 | candidate 69 | 91490 |  |  |  |  |  | 9 |  |  | candidate 88 | 71834 | Y |  |  |  |  | 9
 | candidate 70 | 67197 |  |  |  |  |  | 2 |  |  | candidate 89 | 91088 |  |  |  |  |  | 2
 | candidate 71 | 94757 | Y |  |  |  |  | 7
 | candidate 72 | 40347 |  |  |  |  |  | 1
 | candidate 73 | 20985 |  |  |  |  |  | 3
 | candidate 74 | 32457 |  |  |  |  |  | 5