Spreadsheet: 41120d1239645553-vlookup-hlookup-problems-problem-example
Sheet: reportSuites

Step 1 | Site (friendly name) 1 | site (lookup name) 1
 | Site (friendly name) 2 | site (lookup name) 2
 | Site (friendly name) 3 | site (lookup name) 3
 | Site (friendly name) 4 | site (lookup name) 4
 | Site (friendly name) 5 | site (lookup name) 5
Step 2 | Site (friendly name) 6 | site (lookup name) 6
 | Site (friendly name) 7 | site (lookup name) 7
 | Site (friendly name) 8 | site (lookup name) 8
 | Site (friendly name) 9 | site (lookup name) 9
 | Site (friendly name) 10 | site (lookup name) 10
Step 3 | Site (friendly name) 11 | site (lookup name) 11
 | Site (friendly name) 12 | site (lookup name) 12
 | Site (friendly name) 13 | site (lookup name) 13
 | Site (friendly name) 14 | site (lookup name) 14
 | Site (friendly name) 15 | site (lookup name) 15
Step 4 | Site (friendly name) 16 | site (lookup name) 16
 | Site (friendly name) 17 | site (lookup name) 17
 | Site (friendly name) 18 | site (lookup name) 18
 | Site (friendly name) 19 | site (lookup name) 19
 | Site (friendly name) 20 | site (lookup name) 20
Step 5 | Site (friendly name) 21 | site (lookup name) 21
 | Site (friendly name) 22 | site (lookup name) 22
 | Site (friendly name) 23 | site (lookup name) 23
 | Site (friendly name) 24 | site (lookup name) 24
 | Site (friendly name) 25 | site (lookup name) 25
Step 6 | Site (friendly name) 26 | site (lookup name) 26
 | Site (friendly name) 27 | site (lookup name) 27
 | Site (friendly name) 28 | site (lookup name) 28
 | Site (friendly name) 29 | site (lookup name) 29
 | Site (friendly name) 30 | site (lookup name) 30
Step 7 | Site (friendly name) 31 | site (lookup name) 31
 | Site (friendly name) 32 | site (lookup name) 32
 | Site (friendly name) 33 | site (lookup name) 33
 | Site (friendly name) 34 | site (lookup name) 34
 | Site (friendly name) 35 | site (lookup name) 35
Step 8 | Site (friendly name) 36 | site (lookup name) 36
 | Site (friendly name) 37 | site (lookup name) 37
 | Site (friendly name) 38 | site (lookup name) 38
 | Site (friendly name) 39 | site (lookup name) 39
 | Site (friendly name) 40 | site (lookup name) 40
Step 9 | Site (friendly name) 41 | site (lookup name) 41
 | Site (friendly name) 42 | site (lookup name) 42
 | Site (friendly name) 43 | site (lookup name) 43
 | Site (friendly name) 44 | site (lookup name) 44
 | Site (friendly name) 45 | site (lookup name) 45
Step 10 | Site (friendly name) 46 | site (lookup name) 46
 | Site (friendly name) 47 | site (lookup name) 47
 | Site (friendly name) 48 | site (lookup name) 48
 | Site (friendly name) 49 | site (lookup name) 49
 | Site (friendly name) 50 | site (lookup name) 50
Step 11 | Site (friendly name) 51 | site (lookup name) 51
 | Site (friendly name) 52 | site (lookup name) 52
 | Site (friendly name) 53 | site (lookup name) 53
 | Site (friendly name) 54 | site (lookup name) 54
 | Site (friendly name) 55 | site (lookup name) 55
Step 12 | Site (friendly name) 56 | site (lookup name) 56
 | Site (friendly name) 57 | site (lookup name) 57
 | Site (friendly name) 58 | site (lookup name) 58
 | Site (friendly name) 59 | site (lookup name) 59
 | Site (friendly name) 60 | site (lookup name) 60
Step 13 | Site (friendly name) 61 | site (lookup name) 61
 | Site (friendly name) 62 | site (lookup name) 62
 | Site (friendly name) 63 | site (lookup name) 63
 | Site (friendly name) 64 | site (lookup name) 64
 | Site (friendly name) 65 | site (lookup name) 65
Step 14 | Site (friendly name) 66 | site (lookup name) 66
 | Site (friendly name) 67 | site (lookup name) 67
 | Site (friendly name) 68 | site (lookup name) 68
 | Site (friendly name) 69 | site (lookup name) 69
 | Site (friendly name) 70 | site (lookup name) 70
Step 15 | Site (friendly name) 71 | site (lookup name) 71
 | Site (friendly name) 72 | site (lookup name) 72
 | Site (friendly name) 73 | site (lookup name) 73
 | Site (friendly name) 74 | site (lookup name) 74
 | Site (friendly name) 75 | site (lookup name) 75
Step 16 | Site (friendly name) 76 | site (lookup name) 76
 | Site (friendly name) 77 | site (lookup name) 77
 | Site (friendly name) 78 | site (lookup name) 78
 | Site (friendly name) 79 | site (lookup name) 79
 | Site (friendly name) 80 | site (lookup name) 80
Step 17 | Site (friendly name) 81 | site (lookup name) 81
 | Site (friendly name) 82 | site (lookup name) 82
 | Site (friendly name) 83 | site (lookup name) 83
 | Site (friendly name) 84 | site (lookup name) 84
 | Site (friendly name) 85 | site (lookup name) 85
Step 18 | Site (friendly name) 86 | site (lookup name) 86
 | Site (friendly name) 87 | site (lookup name) 87
 | Site (friendly name) 88 | site (lookup name) 88
 | Site (friendly name) 89 | site (lookup name) 89
 | Site (friendly name) 90 | site (lookup name) 90
Step 19 | Site (friendly name) 91 | site (lookup name) 91
 | Site (friendly name) 92 | site (lookup name) 92
 | Site (friendly name) 93 | site (lookup name) 93
 | Site (friendly name) 94 | site (lookup name) 94
 | Site (friendly name) 95 | site (lookup name) 95
Step 20 | Site (friendly name) 96 | site (lookup name) 96
 | Site (friendly name) 97 | site (lookup name) 97
 | Site (friendly name) 98 | site (lookup name) 98
 | Site (friendly name) 99 | site (lookup name) 99
 | Site (friendly name) 100 | site (lookup name) 100
Step 21 | Site (friendly name) 101 | site (lookup name) 101
 | Site (friendly name) 102 | site (lookup name) 102
 | Site (friendly name) 103 | site (lookup name) 103
 | Site (friendly name) 104 | site (lookup name) 104
 | Site (friendly name) 105 | site (lookup name) 105
Step 22 | Site (friendly name) 106 | site (lookup name) 106
 | Site (friendly name) 107 | site (lookup name) 107
 | Site (friendly name) 108 | site (lookup name) 108
 | Site (friendly name) 109 | site (lookup name) 109
 | Site (friendly name) 110 | site (lookup name) 110
Step 23 | Site (friendly name) 111 | site (lookup name) 111
 | Site (friendly name) 112 | site (lookup name) 112
 | Site (friendly name) 113 | site (lookup name) 113
 | Site (friendly name) 114 | site (lookup name) 114
 | Site (friendly name) 115 | site (lookup name) 115
Step 24 | Site (friendly name) 116 | site (lookup name) 116
 | Site (friendly name) 117 | site (lookup name) 117
 | Site (friendly name) 118 | site (lookup name) 118
 | Site (friendly name) 119 | site (lookup name) 119
 | Site (friendly name) 120 | site (lookup name) 120
Step 25 | Site (friendly name) 121 | site (lookup name) 121
 | Site (friendly name) 122 | site (lookup name) 122
 | Site (friendly name) 123 | site (lookup name) 123
 | Site (friendly name) 124 | site (lookup name) 124
 | Site (friendly name) 125 | site (lookup name) 125
Step 26 | Site (friendly name) 126 | site (lookup name) 126
 | Site (friendly name) 127 | site (lookup name) 127
 | Site (friendly name) 128 | site (lookup name) 128
 | Site (friendly name) 129 | site (lookup name) 129
 | Site (friendly name) 130 | site (lookup name) 130
Step 27 | Site (friendly name) 131 | site (lookup name) 131
 | Site (friendly name) 132 | site (lookup name) 132
 | Site (friendly name) 133 | site (lookup name) 133
 | Site (friendly name) 134 | site (lookup name) 134
 | Site (friendly name) 135 | site (lookup name) 135
Step 28 | Site (friendly name) 136 | site (lookup name) 136
 | Site (friendly name) 137 | site (lookup name) 137
 | Site (friendly name) 138 | site (lookup name) 138
 | Site (friendly name) 139 | site (lookup name) 139
 | Site (friendly name) 140 | site (lookup name) 140
Step 29 | Site (friendly name) 141 | site (lookup name) 141
 | Site (friendly name) 142 | site (lookup name) 142
 | Site (friendly name) 143 | site (lookup name) 143
 | Site (friendly name) 144 | site (lookup name) 144
 | Site (friendly name) 145 | site (lookup name) 145
Step 30 | Site (friendly name) 146 | site (lookup name) 146
 | Site (friendly name) 147 | site (lookup name) 147
 | Site (friendly name) 148 | site (lookup name) 148
 | Site (friendly name) 149 | site (lookup name) 149
 | Site (friendly name) 150 | site (lookup name) 150
Step 31 | Site (friendly name) 151 | site (lookup name) 151
 | Site (friendly name) 152 | site (lookup name) 152
 | Site (friendly name) 153 | site (lookup name) 153
 | Site (friendly name) 154 | site (lookup name) 154
 | Site (friendly name) 155 | site (lookup name) 155
Step 32 | Site (friendly name) 156 | site (lookup name) 156
 | Site (friendly name) 157 | site (lookup name) 157
 | Site (friendly name) 158 | site (lookup name) 158
 | Site (friendly name) 159 | site (lookup name) 159
 | Site (friendly name) 160 | site (lookup name) 160
Step 33 | Site (friendly name) 161 | site (lookup name) 161
 | Site (friendly name) 162 | site (lookup name) 162
 | Site (friendly name) 163 | site (lookup name) 163
 | Site (friendly name) 164 | site (lookup name) 164
 | Site (friendly name) 165 | site (lookup name) 165
Step 34 | Site (friendly name) 166 | site (lookup name) 166
 | Site (friendly name) 167 | site (lookup name) 167
 | Site (friendly name) 168 | site (lookup name) 168
 | Site (friendly name) 169 | site (lookup name) 169
 | Site (friendly name) 170 | site (lookup name) 170
Step 35 | Site (friendly name) 171 | site (lookup name) 171
 | Site (friendly name) 172 | site (lookup name) 172
 | Site (friendly name) 173 | site (lookup name) 173
 | Site (friendly name) 174 | site (lookup name) 174
 | Site (friendly name) 175 | site (lookup name) 175
Step 36 | Site (friendly name) 176 | site (lookup name) 176
 | Site (friendly name) 177 | site (lookup name) 177
 | Site (friendly name) 178 | site (lookup name) 178
 | Site (friendly name) 179 | site (lookup name) 179
 | Site (friendly name) 180 | site (lookup name) 180
Step 37 | Site (friendly name) 181 | site (lookup name) 181
 | Site (friendly name) 182 | site (lookup name) 182
 | Site (friendly name) 183 | site (lookup name) 183
 | Site (friendly name) 184 | site (lookup name) 184
 | Site (friendly name) 185 | site (lookup name) 185
Step 38 | Site (friendly name) 186 | site (lookup name) 186
 | Site (friendly name) 187 | site (lookup name) 187
 | Site (friendly name) 188 | site (lookup name) 188
 | Site (friendly name) 189 | site (lookup name) 189
 | Site (friendly name) 190 | site (lookup name) 190