Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: HazardCauseData

HazardCauseID | HazardID | CauseID | Priority | Contribution
519500 | 441043 | 606876 | 1
519500 | 441053 | 606878 | 2
519500 | 441200 | 606879 | 3
519500 | 441186 | 606881 | 1
519500 | 441176 | 606882 | 1
519500 | 441048 | 606883 | 2
519500 | 441049 | 606884 | 1
519500 | 441039 | 606885 | 2
519500 | 441040 | 606886 | 1
519500 | 441166 | 606887 | 1
519500 | 441158 | 606888 | 1
519500 | 441160 | 606890 | 1
519500 | 441162 | 606891 | 1
519500 | 441155 | 606896 | 2
519500 | 441156 | 606897 | 2
519500 | 441179 | 606900 | 1
519501 | 441070 | 606901 | 3
519502 | 441037 | 606902 | 2
519503 | 441058 | 606903 | 1
519503 | 441107 | 606904 | 1
519503 | 441037 | 606905 | 2
519503 | 441051 | 606906 | 2
519504 | 441183 | 606908 | 2
519504 | 441180 | 606909 | 2
519504 | 441165 | 606913 | 1
519504 | 441146 | 606915 | 2
519504 | 441195 | 606916 | 2
519504 | 441207 | 606917 | 1
519505 | 441115 | 606918 | 3
519505 | 441141 | 606919 | 3
519506 | 441144 | 606920 | 3
519506 | 441145 | 606921 | 3
519506 | 441134 | 606922 | 3
519506 | 441184 | 606923 | 2
519492 | 441180 | 606924 | 2
519492 | 441197 | 606925 | 3
519492 | 441208 | 606927 | 2
519493 | 441030 | 606929 | 2
519494 | 441189 | 606932 | 2
519494 | 441116 | 606933 | 2
519495 | 441041 | 606935 | 2
519495 | 441148 | 606936 | 2
519495 | 441132 | 606937 | 2
519495 | 441110 | 606938 | 2
519495 | 441068 | 606939 | 1
519495 | 441081 | 606940 | 1
519495 | 441079 | 606941 | 2
519495 | 441137 | 606942 | 2
519497 | 441112 | 606943 | 2
519497 | 441113 | 606944 | 2
519497 | 441194 | 606945 | 2
519498 | 441215 | 606948 | 2
519499 | 441215 | 606951 | 2
519499 | 441216 | 606952 | 2
519499 | 441217 | 606955 | 2
519499 | 441089 | 606956 | 3
519487 | 441120 | 606958 | 2
519487 | 441148 | 606959 | 2
519487 | 441136 | 606960 | 2
519487 | 441137 | 606961 | 2
519487 | 441138 | 606962 | 2
519487 | 441139 | 606963 | 2
519487 | 441128 | 606964 | 2
519487 | 441129 | 606965 | 3
519487 | 441130 | 606966 | 2
519487 | 441121 | 606968 | 2
519487 | 441036 | 606969 | 2
519487 | 441149 | 606973 | 2
519488 | 441161 | 606974 | 2
519488 | 441130 | 606976 | 2
519488 | 441125 | 606977 | 2
519490 | 441104 | 606980 | 1
519490 | 441053 | 606981 | 2
519491 | 441121 | 606982 | 2
519491 | 441178 | 606985 | 2
519491 | 441173 | 606986 | 2
519507 | 441135 | 606987 | 2
519507 | 441169 | 606988 | 1
519507 | 441136 | 606990 | 2
519507 | 441125 | 606991 | 2
519507 | 441137 | 606992 | 2
519508 | 441174 | 606993 | 2
519508 | 441131 | 606994 | 2
519508 | 441124 | 606995 | 2
519508 | 441121 | 606997 | 2
519508 | 441212 | 606998 | 1
519508 | 441098 | 607000 | 2
519509 | 441103 | 607002 | 2
519509 | 441092 | 607003 | 2
519509 | 441097 | 607006 | 2
519510 | 441099 | 607007 | 2
519510 | 441102 | 607008 | 2
519511 | 441115 | 607009 | 3
519511 | 441072 | 607010 | 3
519511 | 441062 | 607013 | 3
519511 | 441060 | 607014 | 1
519512 | 441115 | 607015 | 3
519512 | 441140 | 607016 | 2
519512 | 441036 | 607017 | 2
519514 | 441107 | 607018 | 1
519514 | 441108 | 607019 | 2
519515 | 441051 | 607020 | 2
519516 | 441108 | 607021 | 2
519516 | 441103 | 607022 | 2
519516 | 441092 | 607023 | 2
519516 | 441051 | 607028 | 2
519517 | 441209 | 607029 | 1
519517 | 441172 | 607030 | 2
519517 | 441127 | 607031 | 2
519517 | 441104 | 607032 | 1
519517 | 441065 | 607033 | 1
519517 | 441071 | 607034 | 1
519517 | 441143 | 607035 | 3
519517 | 441067 | 607036 | 1
519502 | 441031 | 607037 | 2
519502 | 441066 | 607038 | 1
519501 | 441206 | 607040 | 3
519500 | 441032 | 607041 | 1
519492 | 441223 | 607042 | 2
519495 | 441225 | 607045 | 2
519506 | 441228 | 607046 | 2
519492 | 441222 | 607048 | 2
519508 | 441231 | 607053 | 2
519516 | 441232 | 607054 | 2
519499 | 441233 | 607055 | 2
519498 | 441233 | 607056 | 2
519506 | 441233 | 607057 | 2
519492 | 441233 | 607058 | 2
519502 | 441233 | 607059 | 2
519506 | 441235 | 607060 | 2
519494 | 441190 | 607061 | 2
519510 | 441210 | 607076 | 2
519510 | 441213 | 607077 | 2
519510 | 441106 | 607079 | 2
519508 | 441109 | 607081 | 2
519508 | 441081 | 607082 | 1
519489 | 441105 | 607083 | 2
519489 | 441034 | 607084 | 3
519490 | 441034 | 607085 | 3
519489 | 441234 | 607086 | 2
519493 | 441148 | 607087 | 2
519505 | 441193 | 607088 | 3
519500 | 441214 | 607090 | 2
519502 | 441236 | 607091 | 2
519496 | 441181 | 607092 | 2
519500 | 441170 | 607093 | 2
519500 | 441090 | 607094 | 2
519517 | 441188 | 607095 | 2
519513 | 441229 | 607096 | 2
519492 | 441192 | 607097 | 3
519487 | 441135 | 607099 | 2
519497 | 441237 | 607100 | 2
519496 | 441237 | 607101 | 2
519489 | 441238 | 607102 | 2
519487 | 441239 | 607103 | 2
519495 | 441126 | 607104 | 2
519487 | 441033 | 607105 | 2
519507 | 441033 | 607106 | 2
519495 | 441211 | 607107 | 2
519503 | 441240 | 607108
519499 | 441240 | 607109
519518 | 441244 | 607112
519518 | 441245 | 607113
519518 | 441242 | 607114
519519 | 441247 | 607115
519519 | 441248 | 607116
519519 | 441246 | 607117
519519 | 441249 | 607118
519520 | 441251 | 607119
519520 | 441250 | 607120
519520 | 441252 | 607121
519520 | 441258 | 607122
519520 | 441260 | 607123
519520 | 441254 | 607124
519520 | 441261 | 607125
519520 | 441257 | 607126
519520 | 441253 | 607127
519520 | 441259 | 607128
519520 | 441255 | 607129
519520 | 441256 | 607130
519506 | 441262 | 607131
519493 | 441175 | 607134
519506 | 441263 | 607135
519506 | 441264 | 607136
519518 | 441266 | 607137
519500 | 441268 | 607138
519490 | 441271 | 607141
519507 | 441272 | 607142
519487 | 441272 | 607143
519515 | 441273 | 607144
519516 | 441091 | 607145
519520 | 441274 | 607146
519487 | 441202 | 607147
519508 | 441275 | 607148
519523 | 441219 | 607149
519506 | 441029 | 607150
519494 | 441029 | 607151
519490 | 441029 | 607152
519523 | 441029 | 607153
519493 | 441029 | 607154
519521 | 441226 | 607155
519521 | 441060 | 607156
519521 | 441034 | 607157
519521 | 441114 | 607158
519521 | 441096 | 607159
519521 | 441069 | 607160
519522 | 441203 | 607161
519522 | 441054 | 607162
519523 | 441192 | 607163
519521 | 441167 | 607164
519521 | 441091 | 607165
519521 | 441168 | 607166
519521 | 441171 | 607167
519521 | 441147 | 607168
519521 | 441133 | 607170
519521 | 441029 | 607171
519521 | 441055 | 607173
519521 | 441044 | 607174
519521 | 441221 | 607175
519521 | 441267 | 607176
519524 | 441070 | 607178
519524 | 441059 | 607180
519524 | 441206 | 607181
519524 | 441090 | 607183
519524 | 441155 | 607184
519524 | 441156 | 607185
519524 | 441170 | 607186
519524 | 441185 | 607187
519524 | 441220 | 607188
519524 | 441207 | 607189
519510 | 441276 | 607190
519525 | 441276 | 607191
519489 | 441130 | 607192
519489 | 441272 | 607193
519489 | 441098 | 607194
519489 | 441109 | 607195
519489 | 441231 | 607196
519489 | 441232 | 607197
519523 | 441143 | 607198
519523 | 441200 | 607199
519487 | 441277 | 607200
519493 | 441132 | 673700
519523 | 441042 | 681478
519524 | 441042 | 681479
519523 | 441039 | 681480
519524 | 441039 | 681481
519524 | 441147 | 681485
519487 | 441212 | 681486
519491 | 441212 | 681487
519524 | 509575 | 686568
519524 | 509576 | 686569
519504 | 509576 | 686570
519511 | 509577 | 686571
519502 | 509578 | 686572
519499 | 509578 | 686573
519502 | 509579 | 686574
519487 | 509580 | 686576
519502 | 509581 | 686577
519516 | 441069 | 705886
519502 | 441133 | 705887
519506 | 441133 | 705888
519492 | 441133 | 705889
519493 | 441133 | 705890
519497 | 441133 | 705891
519499 | 441133 | 705892
519498 | 441133 | 705893
519490 | 441133 | 705894
519491 | 441133 | 705895
519508 | 441133 | 705896
519510 | 441133 | 705897
519520 | 441133 | 705898
519523 | 441133 | 705899
519524 | 441133 | 705900
519524 | 441054 | 705901
519523 | 441214 | 705902
519524 | 441214 | 705903
519487 | 441110 | 705905
519513 | 441213 | 705906
519510 | 441100 | 705907
519489 | 441101 | 705908
519501 | 441034 | 705968
519502 | 441034 | 705969
519503 | 441034 | 705970
519504 | 441034 | 705971
519506 | 441034 | 705972
519492 | 441034 | 705973
519493 | 441034 | 705974
519496 | 441034 | 705975
519497 | 441034 | 705976
519499 | 441034 | 705977
519498 | 441034 | 705978
519487 | 441034 | 705979
519491 | 441034 | 705980
519507 | 441034 | 705981
519508 | 441034 | 705982
519510 | 441034 | 705983
519514 | 441034 | 705984
519517 | 441034 | 705985
519520 | 441034 | 705986
519522 | 441034 | 705987
519523 | 441034 | 705988
519524 | 441034 | 705989
519486 | 441038 | 708447
519498 | 441216 | 708448
519524 | 441072 | 708450
519523 | 441078 | 708451
519497 | 441229 | 708490
519492 | 441074 | 715317
519506 | 441082 | 715318
519506 | 441084 | 715319
519506 | 441083 | 715320
519506 | 441074 | 715321
519506 | 441075 | 715322
519506 | 441077 | 715323
519506 | 441076 | 715324
519506 | 441183 | 715325
519515 | 524992 | 715326
519516 | 441107 | 715327
519516 | 441273 | 715328
519516 | 524992 | 715329
519520 | 441238 | 715330
519505 | 441176 | 720076
519505 | 441040 | 720077
519505 | 441160 | 720078
519505 | 441162 | 720079
519511 | 441222 | 726037
519498 | 441240 | 726038
519487 | 441029 | 726039
519492 | 441029 | 726040
519523 | 539824 | 736610
519521 | 539824 | 736611
519505 | 543789 | 742340
519497 | 543789 | 742341
519495 | 441034 | 744138
519523 | 441072 | 773187