Spreadsheet: 879286d1726751627-lookup-or-index-formula-question-example
Sheet: Sheet1

Location | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1st | 1st | 2nd | 2nd | 3rd | 3rd
1 | 0 | 0 | 0.005800330349940461 | 0.127684093266239 | 0 | 0.2564437444781623 | 0.023739100372604 | 0 | 0.00272730764798525 | 0.06318902930895402 | 0.1689010102562133 | 0.05638996658087812 | 0.0290016517497023 | 0 | 0.0568509199861714 | 0.02012829869780663 | 0.08589098451964813 | 0.05523758306764491 | 0.003149848269504091 | 0.01724733991472362 | 0.01759305496869358 | 0.009756847078707795 | 0.005800330349940461 | 0.127684093266239 | 0.3460991818077056 | 0.3111435485729651 | 0.2542926285867937 | 0.03799024315292129 | 0.009756847078707795 | 0.3460991818077056 | Score 25 | 0.3111435485729651 | Score 26 | 0.2564437444781623 | Score 6
2 | 0 | 0 | 0.2907724756129713 | 0.2703401001845505 | 0.002056419720537833 | 0.03118903242815713 | 0.04748220406011073 | 0 | 0.02620616925916161 | 0.05692064329027155 | 0.04344845768520959 | 0.004191932507250197 | 0.02726074347482204 | 0 | 0.0165568151858687 | 0.02918534141840232 | 0.03762193514368574 | 0.04286844186659636 | 0.02306881096757184 | 0.01537041919325072 | 0.01399947271289217 | 0.02122330609016609 | 0.2907724756129713 | 0.2723965199050883 | 0.161798049037701 | 0.09145794885315053 | 0.07490113366728182 | 0.05243870287371474 | 0.02122330609016609 | 0.2907724756129713 |  | 0.2907724756129713 |  | 0.2723965199050883
3 | 0 | 0 | 0.0003295028625561185 | 0.06112278100415997 | 0 | 0.07352032620783393 | 0.09378475225503521 | 0 | 0 | 0.02104699534577207 | 0.01437456237901067 | 0.04431813501379793 | 0 | 0 | 0.09456732155360599 | 0.01268586020841056 | 0.02817249474854813 | 0.1769842250504551 | 0.2080398698463693 | 0.1094361382264508 | 0.05906338811318423 | 0.002347707895712344 | 0.0003295028625561185 | 0.06112278100415997 | 0.1883520738086412 | 0.1532600189464146 | 0.05869269739280859 | 0.3765393961860044 | 0.002347707895712344 | 0.3765393961860044 |  | 0.2080398698463693 |  | 0.1883520738086412
4 | 0 | 0 | 0 | 0.04937308292525427 | 0 | 0.1242533498358715 | 0.04194694075230049 | 0 | 0 | 0.01221546574826454 | 0.04000968627239951 | 0.0485927998708497 | 0 | 0 | 0.1018403917559059 | 0.02416186837432062 | 0.04113975138567508 | 0.269251466394016 | 0.1071678415756336 | 0.07248560512296184 | 0.0382338696658236 | 0.02636818597643007 | 0 | 0.04937308292525427 | 0.1784157563364365 | 0.1904428778991551 | 0.08860248614324921 | 0.2178873163644191 | 0.02636818597643007 | 0.269251466394016 |  | 0.2178873163644191 |  | 0.1904428778991551
5 | 0 | 0 | 0.00514344131365408 | 0.1409814069388537 | 0.007124145422017762 | 0.09239026260302856 | 0.03795284646348476 | 0 | 0 | 0.1716184269375759 | 0.06942048431410133 | 0.05268033991438247 | 0.168359849210913 | 0 | 0.05322343620215961 | 0.004504504504504504 | 0.06229633889208357 | 0.0374416970161651 | 0.007795029071624817 | 0.02354482141716184 | 0.002076544629736119 | 0.06156156156156156 | 0.00514344131365408 | 0.1481055523608715 | 0.3019615360040891 | 0.3436841096415565 | 0.2904606734393969 | 0.03341639511852278 | 0.06156156156156156 | 0.3436841096415565 |  | 0.3019615360040891 |  | 0.2904606734393969
6 | 0 | 0 | 0 | 0.00822364359271973 | 0 | 0.1250339564863063 | 0.006050428469118119 | 0 | 0 | 0.002148519497197046 | 0.3048922035907441 | 0.06564097498333045 | 0 | 0 | 0.08796582125305609 | 0 | 0.01313807324722792 | 0.08710147432889635 | 0.2401649667843825 | 0.03926604598325636 | 0.003877213345516509 | 0.01412589830341047 | 0 | 0.00822364359271973 | 0.1332329044526215 | 0.4584989998271306 | 0.3705331785740745 | 0.2833082261131553 | 0.01412589830341047 | 0.4584989998271306 |  | 0.3705331785740745 |  | 0.3048922035907441
7 | 0 | 0 | 0.0002420805090607276 | 0.05986305159773136 | 0 | 0.1043021164753078 | 0.03600082999031678 | 0 | 0.0002766634389265458 | 0.01794854060035966 | 0.07106792087425647 | 0.04782819200442662 | 0.005152856550006917 | 0 | 0.117581961543782 | 0.01729146493290912 | 0.01120486927652511 | 0.2554986858486651 | 0.07141375017291465 | 0.08711440033199613 | 0.07642827500345829 | 0.01812145524968875 | 0.0002420805090607276 | 0.05986305159773136 | 0.1585281505049108 | 0.241630930972472 | 0.12404896942869 | 0.2349564255083691 | 0.01812145524968875 | 0.2554986858486651 |  | 0.241630930972472 |  | 0.2349564255083691
8 | 0.001834862385321101 | 0.1171352471145309 | 0 | 0 | 0.1367860313702279 | 0 | 0 | 0.02894347440071027 | 0.2077241787511098 | 0 | 0 | 0 | 0 | 0.03074874223142942 | 0 | 0.281621781592187 | 0 | 0 | 0.184166913287955 | 0 | 0.005682154483575022 | 0.005179047055341817 | 0.118970109499852 | 0.1367860313702279 | 0.2366676531518201 | 0.03074874223142942 | 0 | 0.18984906777153 | 0.005179047055341817 | 0.281621781592187 |  | 0.2366676531518201 |  | 0.2077241787511098
9 | 0 | 0 | 0.04508620997394067 | 0.2018705600970978 | 0 | 0.1729197158462143 | 0.07478670617213437 | 0 | 0.0006068611002034769 | 0.01131617463320601 | 0.09263556206047192 | 0.04712097954521115 | 0 | 0 | 0.052082961482169 | 0.03991004176632278 | 0.008139078285081926 | 0.1624959840074251 | 0.01456466640488345 | 0.03487666440581159 | 0.02156141791311177 | 0.02002641630671474 | 0.04508620997394067 | 0.2018705600970978 | 0.2596294577517581 | 0.1918395030878521 | 0.1397565416056831 | 0.0710027487238068 | 0.02002641630671474 | 0.2596294577517581 |  | 0.2018705600970978 |  | 0.2018705600970978
10 | 0 | 0 | 0 | 0 | 0 | 0.119465981557095 | 0 | 0 | 0 | 0 | 0.3505069504977749 | 0.02550809744460247 | 0 | 0 | 0.1500206450428958 | 0 | 0.03807863467449649 | 0.06372436573840437 | 0.1606184337294123 | 0.06381612148460797 | 0.01335046107262467 | 0.01491030875808597 | 0 | 0 | 0.119465981557095 | 0.5260356929852732 | 0.3760150479423774 | 0.2377850162866449 | 0.01491030875808597 | 0.5260356929852732 |  | 0.3760150479423774 |  | 0.3505069504977749
11 | 0 | 0 | 0 | 0.03882618510158013 | 0 | 0.1810794171967987 | 0 | 0 | 0 | 0.0008208495793145906 | 0.3267391750461728 | 0.02885286271290786 | 0 | 0 | 0.1546070182639031 | 0 | 0.03804637800123128 | 0.03340857787810383 | 0.1259593679458239 | 0.05598194130925508 | 0.004843012517956085 | 0.0108352144469526 | 0 | 0.03882618510158013 | 0.1819002667761133 | 0.5101990560229838 | 0.3555920377590807 | 0.1867843217730351 | 0.0108352144469526 | 0.5101990560229838 |  | 0.3555920377590807 |  | 0.3267391750461728
12 | 0 | 0 | 0.006392329204954055 | 0.09820215741110667 | 0 | 0.1479025169796244 | 0.03363963244107072 | 0 | 0.00111865761086696 | 0.05169796244506592 | 0.1633240111865761 | 0.04962045545345585 | 0 | 0 | 0.1481422293248102 | 0.007351178585697163 | 0.05249700359568518 | 0.08373951258489812 | 0.04250898921294446 | 0.04274870155813024 | 0.004794246903715541 | 0.06400319616460248 | 0.006392329204954055 | 0.09820215741110667 | 0.234358769476628 | 0.3610866959648422 | 0.212944466640032 | 0.09005193767479024 | 0.06400319616460248 | 0.3610866959648422 |  | 0.234358769476628 |  | 0.212944466640032
13 | 0 | 0 | 0 | 0.04357228305880188 | 0 | 0.05627128002208522 | 0.005245237876138769 | 0 | 0 | 0.02608815680500598 | 0.02144106009018128 | 0.08143921965583878 | 0.1479709211373884 | 0 | 0.02318947271556087 | 0.04693107573387319 | 0.1103800496917273 | 0.3073525351983068 | 0.05033587926750713 | 0.03855709947547621 | 0.04122572927210822 | 0 | 0 | 0.04357228305880188 | 0.08760467470322997 | 0.2740406735989694 | 0.2508512008834085 | 0.1301187080150916 | 0 | 0.3073525351983068 |  | 0.2740406735989694 |  | 0.2508512008834085
14 | 0 | 0 | 0.005141388174807198 | 0.1380711501782901 | 0 | 0.1193576028968682 | 0.03891975564585234 | 0 | 0 | 0.04895375514829865 | 0.02753130441993532 | 0.04052298421649114 | 0.008292561572269675 | 0 | 0.1111203250684136 | 0.03488404234734777 | 0.04044005860076844 | 0.2620725875556293 | 0.04942366697072726 | 0.02587279210548138 | 0.04323188766343257 | 0.006164137435387124 | 0.005141388174807198 | 0.1380711501782901 | 0.2072311136910192 | 0.1874671752771098 | 0.07634685020869614 | 0.1185283467396412 | 0.006164137435387124 | 0.2620725875556293 |  | 0.2072311136910192 |  | 0.1874671752771098
15 | 0 | 0 | 0.2527943097691973 | 0.4416098127449558 | 0 | 0.02522136739730005 | 0.1335825228625345 | 0 | 0.01172158513572362 | 0.03374945565394107 | 0.03080998693569459 | 0.007294237189722746 | 0.0006169255334591378 | 0 | 0.02246334736536507 | 0.01694730730149514 | 0.0004354768471476266 | 0.005770068224706053 | 0.004318478734213965 | 0.003048337930033387 | 0 | 0.008999854841050951 | 0.2527943097691973 | 0.4416098127449558 | 0.2042749310494992 | 0.06118449702424154 | 0.03872114965887647 | 0.007366816664247352 | 0.008999854841050951 | 0.4416098127449558 |  | 0.4416098127449558 |  | 0.2527943097691973
16 | 0 | 0.002063983488132095 | 0.03876418988648091 | 0.06449948400412797 | 0.06511222910216719 | 0.01322239422084623 | 0.03573271413828689 | 0.01496388028895769 | 0.05798503611971104 | 0.05872678018575851 | 0.01061016511867905 | 0.01254514963880289 | 0.03682920536635707 | 0.2175567595459236 | 0.001547987616099071 | 0.2128160474716202 | 0.005127708978328174 | 0.01686661506707946 | 0.0316047471620227 | 0.008191434468524252 | 0.05269607843137255 | 0.0412796697626419 | 0.040828173374613 | 0.1296117131062952 | 0.1806308049535604 | 0.2790892672858617 | 0.05998452012383901 | 0.0924922600619195 | 0.0412796697626419 | 0.2790892672858617 |  | 0.2175567595459236 |  | 0.2128160474716202
17 | 0 | 0 | 0.04264233690970319 | 0.1267914480382176 | 0 | 0.05787453990132352 | 0.09953794345680946 | 0 | 0.003994048085206359 | 0.01327433628318584 | 0.06735061477014645 | 0.05826611324301042 | 0.01887383506930848 | 0 | 0.01390085362988488 | 0.05454616649698488 | 0.03234395802333777 | 0.2027566763254758 | 0.1203696452345524 | 0.03900070483201504 | 0.02944631529485472 | 0.01809068838593468 | 0.04264233690970319 | 0.1267914480382176 | 0.1746808677265252 | 0.1583914167123502 | 0.1444905630824654 | 0.1888166653614222 | 0.01809068838593468 | 0.2027566763254758 |  | 0.1888166653614222 |  | 0.1746808677265252