Spreadsheet: 784108d1655451941-reference-a-range-based-on-one-adjacent-cell-sample-data
Sheet: Sheet1

 |  |  |  | 0.6
 |  |  |  | 0.3933166526716222 |  | 0.6218586735302781
 |  |  |  | 0.1238261138320506 |  | 0.03727557831648098 |  |  |  |  | 0.55
 |  |  |  | 0.6681228783092764 |  | 0.7589372212589833
 |  |  |  | 0.230232973530679 |  | 0.006153949857922281 |  |  |  | Result
 |  |  |  | 0.852986178601785 |  | 0.4584021581976749
 |  |  |  | 0.4531967623518531 |  | 0.4498938888408845 |  |  |  | cross-check
 |  |  |  | 0.02436814867923387 |  | 0.9003470420536148
 |  |  |  | 0.6471790728702127 |  | 0.4236490838272164
 |  |  |  | 0.6482905860529725 |  | 0.8809316420189517
 |  |  |  | 0.422842835331422 |  | 0.08101626484363833
 |  |  |  | 0.9076094393037379 |  | 0.7533064143395103
 |  |  |  | 0.8295836816003841 |  | 0.5721249296835138
 |  |  |  | 0.4494302554296559 |  | 0.2614689309445344
 |  |  |  | 0.2496362530911014 |  | 0.2148257729749927
 |  |  |  | 0.5793548799036172 |  | 0.05256082530181316
 |  |  |  | 0.2792935416809087 |  | 0.1508689990238907
 |  |  |  | 0.2621461115407339 |  | 0.2223320462255586
 |  |  |  | 0.2235773703232453 |  | 0.449550244133776
 |  |  |  | 0.694572496220217 |  | 0.1715551167967252
 |  |  |  | 0.2537245391695242 |  | 0.8085156305569168
 |  |  |  | 0.1502445342959209 |  | 0.7639559207181429
 |  |  |  | 0.353616543583218 |  | 0.990398440612987
 |  |  |  | 0.5439474924940545 |  | 0.4366887213986692
 |  |  |  | 0.6405540246189755 |  | 0.2092513170272393
 |  |  |  | 0.95089815476117 |  | 0.2092979017512757
 |  |  |  | 0.9295215523275095 |  | 0.005015854249535545
 |  |  |  | 0.09909860597576392 |  | 0.5765728806667677
 |  |  |  | 0.3721879475324644 |  | 0.8102755996948823
 |  |  |  | 0.06906841986440837 |  | 0.1990526599736542
 |  |  |  | 0.9112414228602301 |  | 0.9780309938114702
 |  |  |  | 0.6329731484548113 |  | 0.2158740616625086
 |  |  |  | 0.05795836911867325 |  | 0.5727800601176376
 |  |  |  | 0.0860197714540043 |  | 0.3011359969900309
 |  |  |  | 0.610446195071344 |  | 0.4372420443022658
 |  |  |  | 0.9176706778032976 |  | 0.1935122019345865
 |  |  |  | 0.4439937471238981 |  | 0.4834643652944417
 |  |  |  | 0.4246191398837298 |  | 0.7491878418948118
 |  |  |  | 0.847929929186352 |  | 0.1088894279284608
 |  |  |  | 0.63103046696485 |  | 0.4339593903859471
 |  |  |  | 0.5289319326319764 |  | 0.3497261998418622
 |  |  |  | 0.3905293194623428 |  | 0.4170302577874129
 |  |  |  | 0.7473177898752353 |  | 0.613823047017628
 |  |  |  | 0.7682036751930525 |  | 0.2985357321515432
 |  |  |  | 0.1111541041114844 |  | 0.7957219725364529
 |  |  |  | 0.6402753421345478 |  | 0.9496315230791704
 |  |  |  | 0.9299904136343852 |  | 0.5173386881648637
 |  |  |  | 0.7232636169671022 |  | 0.413016761079153
 |  |  |  | 0.4633908118038726 |  | 0.0521887710843113
 |  |  |  | 0.2356342200349404 |  | 0.7917536313366488
 |  |  |  | 0.7491911666045038 |  | 0.899500457221893
 |  |  |  | 0.2397178879309318 |  | 0.9011925453144398
 |  |  |  | 0.2625293514096159 |  | 0.7119312718848956
 |  |  |  | 0.4373940565923533 |  | 0.6886147947573079
 |  |  |  | 0.9221743288886505 |  | 0.168257019574422
 |  |  |  | 0.9483299536569612 |  | 0.1358553104468796
 |  |  |  | 0.319995767794557 |  | 0.7246917832572708
 |  |  |  | 0.6382587626781897 |  | 0.4004050724086602
 |  |  |  | 0.2363159681429344 |  | 0.3433345259464857
 |  |  |  | 0.9984073838641171 |  | 0.337798140400982
 |  |  |  | 0.3975359754215494 |  | 0.08787653179250521