Spreadsheet: 166002d1341425126-lookup-value-across-columns-and-return-value-2-columns-further-excel-test-clean-up
Sheet: Data

Participant | Visit | Date | Score | Visit | Date | Score | Visit | Date | Score | Visit | Date | Score | Visit | Date | Score | Visit | Date | Score
1 | 1 |  | 0.0187846728052139 | 3 |  | 0.5085641300541943 | 4 |  | 0.2679521168305037 | 6 |  | 0.09578183146075814 | 7 |  | 0.2483107829793267 | 8 |  | 0.1425450247574551
2 | 3 |  | 0.5290710294047285 | 5 |  | 0.9216382272916086 | 6 |  | 0.7437045196375509 |  |  |  | 8 |  | 0.6844312226766718 | 9 |  | 0.6567272692035386
3 | 1 |  | 0.03338981749566194 | 2 |  | 0.1565288617288267 |  |  |  | 4 |  | 0.389463304318679 | 6 |  | 0.5618909481066163
4 | 4 |  | 0.6387529194592476 |  |  |  | 5 |  | 0.8810335845795447 |  |  |  |  |  |  | 9 |  | 0.1407656820025593
5 | 3 |  | 0.4615515674489039 | 6 |  | 0.4120280996863384 | 5 |  | 0.4563763800146339 |  |  |  | 7 |  | 0.302742480323986 | 9 |  | 0.7343370387121608
6 | 5 |  | 0.9778156639710849 | 4 |  | 0.2375271573142528 |  |  |  |  |  |  |  |  |  | 8 |  | 0.1457639022218578
7 | 1 |  | 0.6828962379052168 | 2 |  | 0.1523160464165385 | 4 |  | 0.894601960783997 |  |  |  | 6 |  | 0.3295867349232071 | 7 |  | 0.287785107592665
8 | 1 |  | 0.7125803911969948 | 6 |  | 0.07065771659263054 |  |  |  |  |  |  |  |  |  | 7 |  | 0.234060777513742
9 |  |  |  | 2 |  | 0.06907143130458593 | 3 |  | 0.1927755314826314 |  |  |  | 5 |  | 0.7896076230610896 | 7 |  | 0.1959109955283109
10 |  |  |  |  |  |  | 4 |  | 0.1248925776185068 |  |  |  |  |  |  | 6 |  | 0.3475300191765344
11 |  |  |  | 1 |  | 0.04070945334655907 | 2 |  | 0.2856701710823892 |  |  |  | 4 |  | 0.3580074053705622 | 5 |  | 0.1894983100347478
12 | 3 |  | 0.1662651804174973 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0.5467738452553323
13 |  |  |  | 6 |  | 0.2625696329539959 |  |  |  |  |  |  | 10 |  | 0.4264248049719221
14 | 2 |  | 0.7157180534718273 |  |  |  | 4 |  | 0.3722403515632993 |  |  |  | 5 |  | 0.6256018028771457 | 6 |  | 0.2883494149203569
15 |  |  |  | 3 |  | 0.7277342540999892 |  |  |  |  |  |  | 7 |  | 0.8426093606623413 | 8 |  | 0.7456878099005522
16 | 1 |  | 0.1946121151707449 |  |  |  | 2 |  | 0.5276611734436558 |  |  |  |  |  |  | 5 |  | 0.7890219819704127
17 |  |  |  | 7 |  | 0.6922560444332264 | 8 |  | 0.4638581739513445 | 9 |  | 0.4051287030463318 | 10 |  | 0.1331370357034789
18 |  |  |  | 4 |  | 0.411312352856962 | 5 |  | 0.5174845311209337 |  |  |  |  |  |  | 9 |  | 0.6526491078284655
19 | 2 |  | 0.4553686794134109 | 3 |  | 0.2997169130177042 | 4 |  | 0.1683372491072523 |  |  |  | 6 |  | 0.2965107838227281 | 7 |  | 0.9375346322138931
20 |  |  |  |  |  |  | 2 |  | 0.6658470215711212 |  |  |  | 3 |  | 0.2080731408064931 | 8 |  | 0.5552551156197245
21 |  |  |  | 2 |  | 0.875516706882693 | 4 |  | 0.5850614991619212 |  |  |  | 5 |  | 0.8531749743549191 | 6 |  | 0.2705627805442132
22 | 1 |  | 0.9706692849171106 |  |  |  |  |  |  |  |  |  | 7 |  | 0.4981118101644761 | 9 |  | 0.7764086836029946
23 |  |  |  |  |  |  | 6 |  | 0.3158138812011249 |  |  |  | 7 |  | 0.3372379419845475 | 8 |  | 0.7731993399643959
24 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0.8847429724436262 | 9 |  | 0.7206784164750908
25 | 3 |  | 0.9388483947951167 | 4 |  | 0.6889546828949051 | 6 |  | 0.4783830704026952 |  |  |  | 8 |  | 0.2545120132822618
26 |  |  |  | 2 |  | 0.5260101759365909 | 3 |  | 0.8956763036628885 |  |  |  | 6 |  | 0.3677446916148384 | 7 |  | 0.1785115516252751
27 | 1 |  | 0.7461808868815043 |  |  |  | 2 |  | 0.9091174979313985 |  |  |  | 5 |  | 0.3425092219923949
28 |  |  |  | 1 |  | 0.0756598941388642 | 2 |  | 0.4893607884023776 |  |  |  | 5 |  | 0.2273883050161754
29 | 2 |  | 0.9475287434276205 |  |  |  | 3 |  | 0.006670098845768635 |  |  |  | 4 |  | 0.4865631071248009 | 5 |  | 0.07037851892198121
30 |  |  |  | 1 |  | 0.2885596446484646 | 2 |  | 0.5129678594760141 |  |  |  | 6 |  | 0.3536320235028008 | 7 |  | 0.9734754606129121