Spreadsheet: 730381d1619681646-match-and-index-function-returns-na-value-not-available-error-index-error-example
Sheet: Sheet1

Sr. No. | Timestamp | A Temperature | B Temperature | C Temperature | D Temperature | E Temperature | F Temperature | G Temperature | H Temperature |  |  | Min Temperature | Corresponding Time
1 | 2021-04-16 17:52:21.480000 | -1.83270276 | 2.63375878 | 1.66919065 | 2.34528708 | 1.30235803 | 2.40766716 | -1.29867351 | 1.83784139
2 | 2021-04-16 17:52:51.530000 | -2.00349379 | 1.78924799 | 1.5850805 | 2.38004661 | 1.37218833 | 2.15428376 | -1.31892467 | 1.61757076
3 | 2021-04-16 17:53:21.540000 | -2.00422812 | 2.38617635 | 1.32826614 | 2.29567957 | 1.38113165 | 2.2189343 | -1.2355057 | 1.4600625
4 | 2021-04-16 17:53:51.470000 | -2.20901442 | 2.0034163 | 1.67796612 | 2.42899084 | 1.44484794 | 2.27989101 | -1.39085293 | 1.71161473
5 | 2021-04-16 17:54:21.470000 | -1.81679833 | 2.73904967 | 1.4271301 | 2.26587415 | 1.34033024 | 2.33881903 | -1.33376861 | 1.48398435
6 | 2021-04-16 17:54:51.470000 | -2.05778337 | 2.78030133 | 1.48038137 | 2.2421329 | 1.29369187 | 2.1671629 | -1.431512 | 1.56523013
7 | 2021-04-16 17:55:21.470000 | -1.8499831 | 1.71346223 | 1.65590763 | 2.19332314 | 1.12142467 | 2.32702494 | -1.32215226 | 1.53858888
8 | 2021-04-16 17:55:51.500000 | -1.90906179 | 2.18777776 | 1.67759025 | 2.2457211 | 1.44148457 | 2.34867358 | -1.29544508 | 1.74816978
9 | 2021-04-16 17:56:21.480000 | -2.04328704 | 1.67891133 | 1.66835618 | 2.44413042 | 1.43643332 | 2.1515727 | -1.44143474 | 1.79119682
10 | 2021-04-16 17:56:51.540000 | -2.23342586 | 1.76567531 | 1.64071929 | 2.41637182 | 1.2631917 | 2.05145526 | -1.49388254 | 1.43782091
11 | 2021-04-16 17:57:21.500000 | -1.98845363 | 2.63674116 | 1.59893441 | 2.43625998 | 1.3416096 | 2.13144445 | -1.38824368 | 1.45497048
12 | 2021-04-16 17:57:51.480000 | -1.96490169 | 1.75645971 | 1.66819823 | 2.20345807 | 1.08316982 | 2.16747761 | -1.49738669 | 1.66261339
13 | 2021-04-16 17:58:21.510000 | -2.03179169 | 2.58411336 | 0.996162057 | 2.33590937 | 1.40694702 | 2.26135159 | -1.37191761 | 1.6498369
14 | 2021-04-16 17:58:51.510000 | -2.11381984 | 2.6258142 | 1.12989295 | 2.39542246 | 1.4022969 | 2.25848031 | -1.43406665 | 1.43833292
15 | 2021-04-16 17:59:21.470000 | -1.96323574 | 1.77356994 | 1.64657354 | 2.37866664 | 1.24003446 | 2.1400423 | -1.50224996 | 1.6203227
16 | 2021-04-16 17:59:51.470000 | -2.02475882 | 2.47555017 | 1.02220249 | 2.23880053 | 1.36288249 | 2.07664347 | -1.38720965 | 1.54582906
17 | 2021-04-16 18:00:21 | -1.96723473 | 1.86123419 | 1.63708782 | 2.36541605 | 1.23885024 | 2.18246961 | -1.28415596 | 1.58177888
18 | 2021-04-16 18:00:50.990000 | -2.02341342 | 2.75234222 | 1.44191933 | 2.31507325 | 1.255885 | 2.06986785 | -1.35936105 | 1.37219548
19 | 2021-04-16 18:01:21 | -2.05229545 | 1.65425253 | 1.77556443 | 2.17632198 | 1.18173659 | 2.01894355 | -1.48635471 | 1.6779629
20 | 2021-04-16 18:01:51 | -2.01169658 | 2.50242329 | 1.15567839 | 2.33445597 | 1.39714956 | 2.1633966 | -1.41393447 | 1.65020669
21 | 2021-04-16 18:02:20.950000 | -2.09161186 | 2.93591046 | 1.31671405 | 2.27707505 | 1.28763425 | 2.05308056 | -1.46477211 | 1.65069067
22 | 2021-04-16 18:02:51 | -2.21163869 | 3.00844646 | 1.38578582 | 2.32501984 | 1.23307037 | 2.07226157 | -1.48803651 | 1.46241295
23 | 2021-04-16 18:03:20.960000 | -2.07894564 | 3.01780629 | 1.0955615 | 2.17682862 | 1.38988483 | 2.16943026 | -1.39078534 | 1.65789866
24 | 2021-04-16 18:03:51.010000 | -1.99578953 | 1.6474905 | 1.6678735 | 2.29538274 | 1.21380472 | 2.05911517 | -1.5436275 | 1.34383726
25 | 2021-04-16 18:04:20.990000 | -1.99289048 | 1.78210104 | 1.64336264 | 2.15632963 | 1.20115972 | 2.15883899 | -1.42510974 | 1.35972476
26 | 2021-04-16 18:04:51.010000 | -2.06648016 | 2.60799789 | 1.70905781 | 2.30247641 | 1.3649081 | 2.0624218 | -1.52932024 | 1.33152199
27 | 2021-04-16 18:05:20.950000 | -2.12052989 | 2.9258306 | 1.40118849 | 2.2709322 | 1.09821749 | 2.0154593 | -1.59980047 | 1.38152242
28 | 2021-04-16 18:05:50.950000 | -2.10965466 | 2.4103477 | 1.24550068 | 2.28996754 | 1.32163298 | 2.06709409 | -1.62559712 | 1.64072728
29 | 2021-04-16 18:06:20.960000 | -1.98821616 | 1.74908531 | 1.67827916 | 2.35377789 | 1.18854618 | 2.01741576 | -1.55190921 | 1.45473385
30 | 2021-04-16 18:06:50.950000 | -2.16423368 | 2.54009867 | 1.60924864 | 2.24153829 | 1.27402973 | 2.02324533 | -1.42668331 | 1.61337364
31 | 2021-04-16 18:07:20.950000 | -2.28747869 | 3.02499771 | 1.11225879 | 2.39865184 | 1.39470625 | 2.01135111 | -1.49507678 | 1.32382512
32 | 2021-04-16 18:07:50.980000 | -2.20034671 | 1.69790089 | 1.39064062 | 2.26617408 | 1.12623501 | 2.03222203 | -1.5835042 | 1.36329103
33 | 2021-04-16 18:08:20.970000 | -2.12816834 | 2.87115383 | 1.36549592 | 2.31791115 | 1.25867438 | 1.91634715 | -1.63770616 | 1.39826357
34 | 2021-04-16 18:08:51.010000 | -2.02233768 | 2.53580713 | 1.5583272 | 2.21846151 | 0.994303763 | 2.05144453 | -1.36115384 | 1.46022272
35 | 2021-04-16 18:09:20.960000 | -2.26803541 | 2.18309903 | 1.17788613 | 2.26148415 | 1.34922743 | 1.88879359 | -1.66589749 | 1.63743007
36 | 2021-04-16 18:09:50.960000 | -2.32552671 | 3.15107417 | 1.18947005 | 2.16742373 | 1.22108936 | 2.07573819 | -1.42587209 | 1.30414939
37 | 2021-04-16 18:10:21 | -2.10757256 | 1.85421765 | 1.34027636 | 2.1809082 | 1.24171698 | 1.95467556 | -1.55770028 | 1.34918308
38 | 2021-04-16 18:10:51.010000 | -2.01339626 | 2.50568104 | 1.54168487 | 2.0440383 | 1.26716673 | 1.96049798 | -1.55897033 | 1.52086914
39 | 2021-04-16 18:11:21 | -2.08157992 | 2.51724887 | 1.56414247 | 2.2040267 | 1.12135339 | 2.01267147 | -1.44351542 | 1.47672367
40 | 2021-04-16 18:11:50.960000 | -2.14475965 | 2.28051615 | 1.5156585 | 2.0453825 | 1.06399512 | 2.05437613 | -1.46148622 | 1.55967903
41 | 2021-04-16 18:12:20.950000 | -2.35361576 | 2.31103325 | 1.49050331 | 2.17500186 | 0.981740534 | 2.07418132 | -1.54729009 | 1.31451881
42 | 2021-04-16 18:12:51.020000 | -2.21545982 | 2.18996596 | 1.1673156 | 2.12703347 | 1.31315291 | 2.07106972 | -1.36965573 | 1.27735019
43 | 2021-04-16 18:13:20.950000 | -2.30685973 | 2.21431661 | 1.17942488 | 2.09889531 | 1.25917232 | 1.89899576 | -1.44834054 | 1.45045197
44 | 2021-04-16 18:13:50.950000 | -2.04473948 | 1.7600565 | 1.63076246 | 2.05346012 | 1.02453876 | 1.91263616 | -1.66259444 | 1.62184751
45 | 2021-04-16 18:14:20.990000 | -2.1888237 | 3.00155997 | 1.26820099 | 2.10710859 | 1.24812424 | 1.97733545 | -1.53994429 | 1.54528296
46 | 2021-04-16 18:14:50.950000 | -2.25335574 | 2.11751533 | 1.17773056 | 2.17215014 | 1.27768171 | 1.97280419 | -1.47284663 | 1.17469931
47 | 2021-04-16 18:15:20.980000 | -2.08934379 | 2.41278362 | 0.993392289 | 2.08194065 | 1.18370295 | 1.85049891 | -1.69313109 | 1.31500375
48 | 2021-04-16 18:15:50.950000 | -2.43085051 | 2.8909688 | 0.887463987 | 2.19195509 | 1.30250549 | 1.96449864 | -1.44260168 | 1.45151937
49 | 2021-04-16 18:16:20.990000 | -2.11707091 | 2.45289016 | 0.89407748 | 2.07907629 | 1.05759132 | 1.99623621 | -1.60642958 | 1.18052828
50 | 2021-04-16 18:16:51.010000 | -2.35607338 | 2.4262054 | 0.910740018 | 2.1641469 | 1.28472948 | 2.01354122 | -1.47500288 | 1.35420966
51 | 2021-04-16 18:17:20.950000 | -2.34225106 | 2.82116055 | 1.22185314 | 2.06860209 | 1.16243947 | 1.83715785 | -1.64644253 | 1.56417918
52 | 2021-04-16 18:17:50.950000 | -2.19390345 | 1.63015473 | 1.38938046 | 1.98402667 | 1.09032714 | 1.94833243 | -1.70555854 | 1.51170707
53 | 2021-04-16 18:18:20.950000 | -2.3888495 | 2.97425818 | 1.0644089 | 2.1678195 | 1.08172679 | 1.93081045 | -1.60445523 | 1.47457302
54 | 2021-04-16 18:18:50.960000 | -2.3871901 | 2.77542949 | 0.840209782 | 2.01155424 | 1.12920594 | 1.98723745 | -1.58358395 | 1.34373736
55 | 2021-04-16 18:19:20.970000 | -2.48958111 | 2.36527824 | 1.45417368 | 2.06654215 | 1.09040105 | 1.94189227 | -1.6161114 | 1.18189597
56 | 2021-04-16 18:19:50.990000 | -2.35013413 | 2.19380546 | 0.808558047 | 2.08217359 | 1.01847363 | 1.95039046 | -1.54979753 | 1.28882957
57 | 2021-04-16 18:20:20.970000 | -2.43210077 | 2.25709796 | 1.16079056 | 2.15973306 | 1.10258305 | 1.98474228 | -1.67666733 | 1.23268831
58 | 2021-04-16 18:20:51.020000 | -2.47029185 | 2.89503908 | 1.09184945 | 2.00517559 | 1.18161762 | 1.97681332 | -1.69523466 | 1.33250713
59 | 2021-04-16 18:21:20.970000 | -2.51782823 | 2.75455141 | 0.95794028 | 1.96338022 | 1.20880747 | 1.81890798 | -1.78213835 | 1.24675655
60 | 2021-04-16 18:21:50.950000 | -2.19310379 | 1.65216863 | 1.35460281 | 2.04308653 | 1.03077424 | 1.9357338 | -1.67634559 | 1.37719107
61 | 2021-04-16 18:22:20.970000 | -2.16253829 | 1.66912067 | 1.52459443 | 2.09432769 | 0.986105978 | 1.90669477 | -1.67359447 | 1.18685794
62 | 2021-04-16 18:22:50.970000 | -2.37926412 | 2.31006789 | 0.782872677 | 2.08466101 | 1.19909906 | 1.91979587 | -1.57603383 | 1.47070062
63 | 2021-04-16 18:23:20.960000 | -2.08038664 | 1.67507517 | 1.57421374 | 1.93338895 | 1.12860775 | 1.8405354 | -1.6359241 | 1.31689799
64 | 2021-04-16 18:23:50.980000 | -2.43301463 | 1.96977305 | 1.08060896 | 2.04047537 | 1.11026728 | 1.96887684 | -1.54388154 | 1.17855358
65 | 2021-04-16 18:24:20.980000 | -2.29099107 | 1.66660726 | 1.50695074 | 1.9166466 | 1.0576483 | 1.80804491 | -1.88021731 | 1.41835487
66 | 2021-04-16 18:24:51.010000 | -2.56276417 | 2.92178822 | 0.759505153 | 2.10619712 | 1.14123595 | 1.95069861 | -1.64593768 | 1.38489902
67 | 2021-04-16 18:25:21.010000 | -2.50373125 | 2.82136822 | 1.34413373 | 2.04306531 | 1.02142584 | 1.94917011 | -1.6955744 | 1.32027853
68 | 2021-04-16 18:25:51.010000 | -2.2401433 | 2.39051628 | 0.821454287 | 1.7601136 | 0.936144531 | 1.85694444 | -1.55448461 | 1.03765833
69 | 2021-04-16 18:26:20.960000 | -2.27938724 | 1.50002718 | 1.21457899 | 1.9983567 | 0.992926061 | 1.86022723 | -1.59430301 | 1.23356628
70 | 2021-04-16 18:26:51.030000 | -2.32188058 | 2.2525661 | 1.14483643 | 2.02917624 | 0.91903317 | 2.00574398 | -1.87776017 | 1.05981314
71 | 2021-04-16 18:27:21.010000 | -2.46559262 | 2.7138989 | 0.841509044 | 1.86347628 | 1.16137671 | 1.88028657 | -1.6806879 | 1.34378231
72 | 2021-04-16 18:27:50.950000 | -2.19596314 | 1.5022186 | 1.21993828 | 1.8653909 | 0.848445415 | 1.9678241 | -1.67589176 | 1.09625947
73 | 2021-04-16 18:28:21.020000 | -2.40451145 | 2.56888461 | 0.910143375 | 2.10175991 | 1.08318865 | 1.77393413 | -1.67055893 | 1.26676595
74 | 2021-04-16 18:28:50.950000 | -2.38632369 | 2.87817407 | 0.868602097 | 2.02338934 | 1.06721735 | 1.78275907 | -1.66722369 | 1.21166241
75 | 2021-04-16 18:29:21.020000 | -2.54927421 | 1.57426143 | 1.11602879 | 1.89167809 | 1.01202917 | 1.78442717 | -1.82420146 | 1.13201511
76 | 2021-04-16 18:29:51 | -2.37513161 | 2.07514191 | 0.938645124 | 1.90091372 | 1.07479203 | 1.9157393 | -1.78981757 | 1.2791568
77 | 2021-04-16 18:30:20.980000 | -2.5618329 | 2.2349658 | 1.27931786 | 1.87503803 | 0.948299468 | 1.8900851 | -1.76601779 | 1.25373852
78 | 2021-04-16 18:30:51 | -2.41788602 | 1.79657912 | 0.905365109 | 1.88770902 | 0.968436241 | 1.84723401 | -1.69844472 | 1.24888289
79 | 2021-04-16 18:31:21 | -2.53650856 | 1.9668963 | 1.26823795 | 2.02587533 | 0.865820765 | 1.98897541 | -1.64170516 | 1.25338483
80 | 2021-04-16 18:31:50.960000 | -2.54818654 | 1.81330204 | 1.23003113 | 1.90383673 | 0.91559273 | 1.81062305 | -1.81068528 | 1.08252001
81 | 2021-04-16 18:32:21.020000 | -2.52905631 | 2.79129505 | 1.12829375 | 2.04824281 | 1.07840371 | 1.86431527 | -1.81461871 | 1.01594377
82 | 2021-04-16 18:32:50.980000 | -2.50777936 | 1.87135768 | 1.01264215 | 1.9287771 | 0.991277516 | 1.91348553 | -1.78213203 | 1.17367578
83 | 2021-04-16 18:33:20.950000 | -2.66973591 | 2.64515471 | 0.744996428 | 1.92591989 | 1.03336453 | 1.62960422 | -1.80372787 | 1.2151705
84 | 2021-04-16 18:33:50.950000 | -2.34681368 | 1.57007337 | 1.18429971 | 1.86313331 | 0.887128532 | 1.78754687 | -1.75668085 | 1.00237727
85 | 2021-04-16 18:34:20.950000 | -2.39088607 | 2.35281849 | 0.708362043 | 1.75964105 | 1.09305692 | 1.80579686 | -1.89330316 | 1.01987267
86 | 2021-04-16 18:34:50.950000 | -2.38087201 | 1.50852537 | 1.22780287 | 1.81484032 | 1.02990949 | 1.90178454 | -1.92394352 | 1.19865477
87 | 2021-04-16 18:35:20.970000 | -2.58025837 | 2.16622925 | 1.17290664 | 1.85288095 | 0.982127726 | 1.75532532 | -1.72145665 | 0.997466087
88 | 2021-04-16 18:35:51.010000 | -2.38556004 | 1.58997214 | 1.01281774 | 1.89072824 | 0.945136964 | 1.82493496 | -1.69115472 | 1.18578136
89 | 2021-04-16 18:36:21 | -2.46267414 | 2.31180549 | 1.1867193 | 1.87935758 | 0.830082297 | 1.75998771 | -1.61779225 | 1.20511115
90 | 2021-04-16 18:36:51 | -2.34809971 | 2.3511591 | 1.23591971 | 1.78633153 | 0.858460426 | 1.98598218 | -1.76636314 | 1.21985042
91 | 2021-04-16 18:37:20.950000 | -2.42315125 | 2.4856298 | 1.04678833 | 1.81101298 | 0.841859579 | 1.80187047 | -1.90152121 | 1.11580658
92 | 2021-04-16 18:37:51.010000 | -2.63421273 | 2.60858798 | 1.03315187 | 1.8778615 | 0.936916292 | 1.75729215 | -1.90395606 | 1.1420002
93 | 2021-04-16 18:38:20.950000 | -2.57575393 | 2.46674871 | 1.01870513 | 1.82880664 | 0.754101396 | 1.81640613 | -1.75136054 | 0.941260278
94 | 2021-04-16 18:38:51.020000 | -2.52232122 | 2.83564854 | 0.643456936 | 1.77358496 | 0.906207204 | 1.82306612 | -1.77262354 | 0.93167454
95 | 2021-04-16 18:39:20.990000 | -2.5874958 | 1.52690816 | 0.806087375 | 1.85663784 | 0.864370286 | 1.94849062 | -1.89127541 | 1.01884842
96 | 2021-04-16 18:39:50.950000 | -2.68338394 | 2.80784345 | 0.754588246 | 1.76860356 | 0.981078506 | 1.77585864 | -1.95960474 | 1.08087289
97 | 2021-04-16 18:40:21.010000 | -2.75939083 | 2.75193977 | 0.865051985 | 1.87736905 | 0.765790224 | 1.84236765 | -1.8097465 | 0.872722089
98 | 2021-04-16 18:40:50.960000 | -2.69115067 | 2.79636383 | 0.553636134 | 1.87519872 | 0.944883347 | 1.81435776 | -1.74452984 | 0.899599493
99 | 2021-04-16 18:41:20.980000 | -1.18861783 | 2.72607684 | 1.35821426 | 1.80810249 | 1.00623584 | 1.85158253 | -1.5622586 | 1.68035042
100 | 2021-04-16 18:41:50.950000 | 0.510871887 | 1.62592471 | 3.00517273 | 2.02142978 | 1.00402129 | 1.81129873 | -1.07501757 | 2.64120555
101 | 2021-04-16 18:42:20.960000 | 0.654193282 | 2.80108309 | 2.52952909 | 2.41104579 | 1.29829621 | 1.80734324 | -0.505138993 | 2.82370925
102 | 2021-04-16 18:42:50.980000 | 0.347948819 | 2.37596107 | 3.25361705 | 2.46749139 | 1.24353051 | 1.97632551 | -0.409913033 | 2.3397243
103 | 2021-04-16 18:43:20.980000 | 1.23655856 | 2.05155587 | 3.61303163 | 2.84973001 | 1.47696459 | 2.10335326 | -0.283400983 | 2.97806811
104 | 2021-04-16 18:43:51 | 1.98553348 | 3.18451214 | 3.83131194 | 2.82796168 | 1.71478891 | 2.11842656 | 0.160861626 | 3.55710983
105 | 2021-04-16 18:44:20.960000 | 1.10431111 | 3.32140708 | 3.25965881 | 2.84336019 | 1.7995466 | 2.36748147 | 0.206816271 | 2.94512391
106 | 2021-04-16 18:44:50.950000 | 2.10410023 | 3.3203342 | 3.89630675 | 3.2128768 | 1.87428617 | 2.45632124 | 0.520130396 | 3.32612491
107 | 2021-04-16 18:45:20.960000 | 2.84407163 | 3.45169759 | 4.44362307 | 3.23683715 | 1.99065208 | 2.45059299 | 0.563468039 | 3.86274981