Spreadsheet: 855626d1705141375-formula-makes-the-cell-to-show-a-blank-result-key-to-the-sun-aligw
Sheet: Sheet3

 |  | HORIZONTAL |  |  |  |  |  |  |  |  | H | V
 | 1 | 1 | 3 | 6 | 32 | 34 | 35 |  | 1 | 11 |  |  |  | WHEN I PUT A NUMBER IN K5
 | 2 | 7 | 8 | 11 | 27 | 28 | 30 |  | 2 | 8 |  |  |  | I WANT IT TO LOOKUP THE REFERENCE NUMBERS IN [NAME]
 | 3 | 14 | 15 | 16 | 19 | 23 | 24 |  | 3 | 35 |  |  |  | ONCE IT FINDS THE MATCHING NUMBER I WANT THE REFERENCE NUMBER IN B3 - B8 \
 | 4 | 13 | 17 | 18 | 20 | 21 | 22 |  | 4 | 8 |  |  |  | TO BE PUT IN TO CELL L5
 | 5 | 9 | 10 | 12 | 25 | 26 | 29 |  | 5 | 22
 | 6 | 2 | 4 | 5 | 31 | 33 | 36 |  | 6 | 2 |  |  |  | BUT THE FORMULA MAKES THE RESULT SHOW UP BLANK
 |  |  |  |  |  |  |  |  | 7 | 12
 |  | VERTICAL |  |  |  |  |  |  | 8 | 22 |  |  |  | WHY IS IT DOING THAT???
 | 1 | 1 | 12 | 13 | 24 | 30 | 31 |  | 9 | 21
 | 2 | 2 | 8 | 17 | 23 | 26 | 35 |  | 10 | 27
 | 3 | 4 | 9 | 15 | 21 | 28 | 34 |  | 11 | 31
 | 4 | 3 | 10 | 16 | 22 | 27 | 33 |  | 12 | 0
 | 5 | 5 | 11 | 14 | 20 | 29 | 32 |  | 13 | 0
 | 6 | 6 | 7 | 18 | 19 | 25 | 26 |  | 14 | 32
 |  |  |  |  |  |  |  |  | 15 | 21
 |  |  |  |  |  |  |  |  | 16 | 24
 |  |  |  |  |  |  |  |  | 17 | 24
 |  |  |  |  |  |  |  |  | 18 | 25
 |  |  |  |  |  |  |  |  | 19 | 19
 |  |  |  |  |  |  |  |  | 20 | 16
 |  |  |  |  |  |  |  |  | 21 | 3
 |  |  |  |  |  |  |  |  | 22 | 27
 |  |  |  |  |  |  |  |  | 23 | 5
 |  |  |  |  |  |  |  |  | 24 | 11
 |  |  |  |  |  |  |  |  | 25 | 30
 |  |  |  |  |  |  |  |  | 26 | 16
 |  |  |  |  |  |  |  |  | 27 | 3
 |  |  |  |  |  |  |  |  | 28 | 9
 |  |  |  |  |  |  |  |  | 29 | 14
 |  |  |  |  |  |  |  |  | 30 | 27
 |  |  |  |  |  |  |  |  | 31 | 16
 |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 101