Spreadsheet: 739303d1625639205-if-vlookup-large-combination-if_vlookup_large-test
Sheet: Data

 | Date | Time | Sample Location | Temperature (°C) | [NAME] (mg/L) | DO (% sat) | pH | EC (uS/cm) | TDS (mg/L) | Salinity (ppt) | Total Alkalinity (CaCO3 mg/L) | Bicarbonate (mg/L) | Carbonate (mg/L) | Ammonia as N (mg/L) | Nitrate + Nitrite (mg/L) | Total N (mg/L) | TKN as N (mg/L) | Nitrite as N (mg/L) | Nitrate as N (mg/L) | Nitrite as NO2(mg/L) | Nitrate as NO3 (mg/L) | Chloride (mg/L) | Sulphate (mg/L) | Aluminium (s) (mg/L) | Manganese (s) (mg/L) | Zinc (s) (mg/L) | Aluminium (t) (mg/L) | Manganese (t) (mg/L) | Iron (t) (mg/L) | Copper (t) (mg/L) | Zinc (t) (mg/L) | Lead (t) (mg/L) | Sodium (mg/L) | Magnesium (mg/L) | Potassium (mg/L) | Calcium (mg/L) | TOC (mg/L) | [NAME] (mg/L) | Turbidity (NTU)
 | 2021-05-28 00:00:00 | 11:39:00 | 1 | 22.1 | 1.8 | 21.7 | 6.7 | 4270 | 2730 | 2.3 | 793 | 793 | <20 | 0.15 | <0.05 | 0.69 | 0.69 | <0.01 | <0.01 | <0.01 | <0.01 | 723 | 153 | 0.03 | 1.68 | 0.03 | 0.56 | 1.79 | 1.69 | 0.007 | 0.05 | 0.01 | 716 | 85.5 | 5.4 | 82.3 | 80 | 32 | 13
 | 2021-05-28 00:00:00 | 11:15:00 | 2 | 21.2 | 2.5 | 29.1 | 6.7 | 6840 | 4310 | 3.7 | 964 | 964 | <20 | 0.05 | <0.05 | 0.16 | 0.16 | <0.01 | <0.01 | <0.01 | <0.01 | 1590 | 116 | 0.01 | 1.19 | 0.02 | 0.9 | 1.25 | 2.78 | 0.009 | 0.221 | 0.02 | 988 | 204 | 4.9 | 231 | 78 | 28 | 22
 | 2021-05-28 00:00:00 | 10:49:00 | 3 | 20.6 | 6 | 69.8 | 6.9 | 4610 | 2950 | 2.5 | 1100 | 1100 | <20 | <0.05 | <0.05 | 0.24 | 0.24 | <0.01 | <0.01 | <0.01 | <0.01 | 762 | 111 | 0.01 | 0.02 | 0.02 | 0.11 | 0.03 | 0.16 | 0.004 | 0.05 | 0.004 | 777 | 107 | 6.1 | 134 | 17 | 8 | 5.8
 | 2021-05-28 00:00:00 | 10:15:00 | 4 | 20.8 | 2.1 | 24.5 | 6.6 | 3000 | 1920 | 1.6 | 690 | 690 | <20 | <0.05 | <0.05 | 0.11 | 0.11 | <0.01 | <0.01 | <0.01 | <0.01 | 485 | 61.8 | 0.01 | 0.8 | 0.02 | 0.19 | 0.84 | 1.03 | 0.003 | 0.02 | 0.004 | 305 | 95.2 | 3.7 | 207 | <5 | 8 | 7.2
 | 2021-05-28 00:00:00 | 09:05:00 | 5 | 20.6 | 2.9 | 33 | 6.9 | 2590 | 1660 | 1.3 | 806 | 806 | <20 | <0.05 | <0.05 | 0.28 | 0.28 | 0.01 | <0.01 | 0.03 | <0.01 | 351 | 39.3 | 0.01 | 0.28 | 0.04 | 0.95 | 0.3 | 2.71 | 0.007 | 0.07 | 0.005 | 384 | 64.6 | 4.1 | 123 | <5 | 35 | 32
 | 2021-05-28 00:00:00 | 07:10:00 | 6 | 20.1 | 2.1 | 24.1 | 6.8 | 2350 | 1510 | 1.2 | 1130 | 1130 | <20 | 0.32 | <0.05 | 0.83 | 0.83 | <0.01 | <0.01 | <0.01 | <0.01 | 119 | 42.9 | 0.01 | 0.95 | 0.02 | 0.41 | 0.96 | 1.7 | 0.007 | 0.05 | 0.003 | 465 | 43.6 | 6.7 | 71.1 | <5 | 47 | 31
 | 2021-02-04 00:00:00 | 10:57:00 | 1 | 23.4 | 4 | 48 | 6.9 | 3770 | 2410 | 2 | 708 | 708 | 20 | 0.14 | <0.05 | 0.61 | 0.61 | <0.01 | <0.01 | <0.01 | <0.01 | 742 | 195 | 0.02 | 1.1 | 0.03 | 0.27 | 1.2 | 0.59 | 0.005 | 0.05 | 0.008 | 600 | 67 | 7.7 | 65 | 8 | 32 | 8.6
 | 2021-02-04 00:00:00 | 10:39:00 | 2 | 23.7 | 3.9 | 48.1 | 6.9 | 6880 | 4340 | 3.8 | 925 | 925 | 20 | <0.05 | <0.05 | 0.09 | 0.09 | <0.01 | <0.01 | <0.01 | <0.01 | 1870 | 149 | 0.01 | 1.2 | 0.1 | 0.15 | 1.2 | 1.3 | 0.001 | 0.14 | 0.004 | 930 | 190 | 7.4 | 220 | <5 | 34 | 9
 | 2021-02-04 00:00:00 | 08:56:00 | 3 | 22.4 | 6.8 | 81.2 | 7 | 4640 | 2970 | 2.5 | 1080 | 1080 | 20 | <0.05 | <0.05 | 0.19 | 0.19 | <0.01 | <0.01 | <0.01 | <0.01 | 919 | 136 | <0.005 | 0.003 | 0.01 | 0.13 | 0.03 | 0.27 | 0.003 | 0.02 | <0.001 | 720 | 98 | 9.4 | 130 | <5 | 20 | 2.7
 | 2021-02-04 00:00:00 | 08:40:00 | 4 | 22.7 | 3.7 | 44.4 | 6.8 | 3000 | 1920 | 1.6 | 684 | 684 | 20 | <0.05 | <0.05 | 0.09 | 0.09 | <0.01 | <0.01 | <0.01 | <0.01 | 591 | 77.6 | <0.005 | 0.68 | 0.01 | 0.08 | 0.7 | 1.1 | <0.001 | 0.01 | <0.001 | 290 | 86 | 4.8 | 200 | <5 | 17 | 12
 | 2021-02-04 00:00:00 | 08:04:00 | 5 | 22.4 | 4.5 | 53 | 6.9 | 2520 | 1610 | 1.3 | 742 | 742 | 20 | <0.05 | <0.05 | 0.1 | 0.1 | <0.01 | <0.01 | <0.01 | <0.01 | 388 | 50.3 | 0.01 | 0.21 | 0.008 | 0.06 | 0.22 | 1.2 | <0.001 | 0.007 | <0.001 | 320 | 60 | 4.5 | 120 | <5 | 15 | 9.6
 | 2021-02-04 00:00:00 | 07:49:00 | 6 | 22.2 | 3.3 | 39.6 | 7 | 2430 | 1550 | 1.2 | 1100 | 1100 | 20 | 0.27 | <0.05 | 0.46 | 0.46 | <0.01 | <0.01 | <0.01 | <0.01 | 132 | 48.9 | <0.005 | 0.95 | <0.005 | 3.9 | 1.1 | 4.9 | 0.006 | 0.03 | 0.009 | 440 | 38 | 9.3 | 64 | <5 | 215 | 76
 | 2020-12-04 00:00:00 | 10:50:00 | 1 | 23.3 | 2.8 | 34.4 | 6.9 | 4920 | 3150 | 2.6 | 987 | <20 | 0.19 | <0.05 | 0.73 | 0.73 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 936 | 236 | 0.01 | 0.98 | 0.02 | 2.24 | 1.04 | 3.68 | 0.01 | 0.06 | 0.02 | 959 | 101 | 7.1 | 91.9 | 5 | 65 | 35
 | 2020-12-04 00:00:00 | 1900-01-10 07:55:12 | 2 | 23.5 | 1.8 | 22.6 | 6.7 | 6740 | 4250 | 3.7 | 948 | 948 | 20 | <0.05 | 0.05 | 0.12 | 0.12 | 0.01 | 0.01 | 0.01 | 0.01 | 1760 | 144 | 0.01 | 1.28 | 0.01 | 0.86 | 1.32 | 2 | 0.006 | 0.197 | 0.01 | 1040 | 199 | 4.5 | 223 | 5 | 29 | 14
 | 2020-12-04 00:00:00 | 08:29:00 | 3 | 21.4 | 5.6 | 66 | 6.9 | 4580 | 2930 | 2.4 | 109 | 109 | 20 | <0.05 | 0.05 | 0.32 | 0.32 | 0.01 | 0.01 | 0.01 | 0.01 | 863 | 137 | 0.01 | 0.002 | 0.01 | 0.03 | 0.02 | 0.04 | 0.001 | 0.01 | 0.003 | 779 | 110 | 5.8 | 134 | 5 | 21 | 4
 | 2020-12-04 00:00:00 | 08:15:00 | 4 | 22.1 | 1.8 | 21.4 | 6.7 | 2950 | 1890 | 1.5 | 693 | 693 | 20 | <0.05 | 0.05 | 0.12 | 0.12 | 0.01 | 0.01 | 0.01 | 0.01 | 549 | 80.3 | 0.01 | 0.78 | 0.01 | 0.11 | 0.81 | 1.04 | 0.001 | 0.01 | 0.003 | 308 | 95.3 | 3.4 | 203 | 5 | 22 | 7.3
 | 2020-12-04 00:00:00 | 07:56:00 | 5 | 22.6 | 1.8 | 21.1 | 6.8 | 2380 | 1520 | 1.2 | 742 | 742 | 20 | <0.05 | 0.05 | 0.12 | 0.12 | 0.01 | 0.01 | 0.01 | 0.01 | 342 | 49.8 | 0.01 | 0.24 | 0.006 | 0.15 | 0.25 | 1.65 | 0.001 | 0.008 | 0.002 | 309 | 69.5 | 3.1 | 127 | 5 | 13 | 16
 | 2020-12-04 00:00:00 | 07:39:00 | 6 | 22.5 | 2.7 | 32.3 | 6.9 | 2320 | 1490 | 1.2 | 1120 | 1120 | 20 | 0.3 | 0.05 | 0.54 | 0.54 | 0.01 | 0.01 | 0.01 | 0.01 | 121 | 48 | 0.01 | 1.13 | 0.007 | 0.3 | 1.15 | 3.01 | 0.002 | 0.02 | 0.001 | 483 | 45.8 | 6.8 | 68.5 | 5 | 21 | 19
 | 2020-09-04 00:00:00 | 08:15:00 | 2 | 21.7 | 4.2 | 50.5 | 6.9 | 6750 | 4250 | 3.7 | 1030 | 1030 | <20 | <0.05 | <0.05 | 0.08 | 0.08 | <0.01 | <0.01 | <0.01 | <0.01 | 1730 | 146 | 0.01 | 1.26 | 0.13 | 0.3 | 1.26 | 2.43 | 0.003 | 0.17 | 0.01 | 1070 | 190 | 4.3 | 224 | <5 | 42 | 20
 | 2020-09-04 00:00:00 | 10:58:00 | 3 | 21 | 5.9 | 69.3 | 7 | 4700 | 3010 | 2.5 | 1190 | 1190 | <20 | <0.05 | <0.05 | 0.22 | 0.22 | <0.01 | <0.01 | <0.01 | <0.01 | 886 | 141 | 0.01 | 0.003 | 0.02 | 0.14 | 0.04 | 0.24 | 0.005 | 0.03 | 0.005 | 800 | 115 | 6.1 | 138 | <5 | 13 | 3.5
 | 2020-09-04 00:00:00 | 10:30:00 | 4 | 21.6 | 3 | 34.9 | 6.8 | 2940 | 1880 | 1.5 | 760 | 760 | <20 | <0.05 | <0.05 | 0.12 | 0.12 | <0.01 | <0.01 | <0.01 | <0.01 | 551 | 76.3 | 0.01 | 0.8 | 0.01 | 0.26 | 0.81 | 1.24 | 0.002 | 0.02 | 0.005 | 305 | 93.3 | 3.4 | 199 | <5 | 14 | 11
 | 2020-09-04 00:00:00 | 07:50:00 | 5 | 21.2 | 1.9 | 22.6 | 6.8 | 2510 | 1610 | 1.3 | 822 | 822 | <20 | <0.05 | <0.05 | 0.25 | 0.25 | <0.01 | <0.01 | <0.01 | <0.01 | 368 | 48.4 | 0.01 | 0.24 | 0.007 | 1.42 | 0.27 | 5.04 | 0.005 | 0.03 | 0.005 | 352 | 63.3 | 3.2 | 117 | <5 | 38 | 29
 | 2020-09-04 00:00:00 | 07:30:00 | 6 | 20.9 | 2.3 | 26.1 | 6.9 | 2350 | 1500 | 1.2 | 1140 | 1140 | <20 | 0.28 | <0.05 | 0.46 | 0.46 | <0.01 | <0.01 | <0.01 | <0.01 | 117 | 46.3 | 0.01 | 1.02 | 0.005 | 16 | 1.41 | 13.2 | 0.03 | 0.95 | 0.03 | 461 | 41.7 | 6.4 | 66.6 | <5 | 674 | 310
 | 2020-05-29 00:00:00 | 09:56:00 | 1 | 22.4 | 1.6 | 19.8 | 7 | 5630 | 3550 | 3 | 992 | 992 | <20 | 0.25 | <0.05 | 1.07 | 1.07 | <0.01 | <0.01 | <0.01 | <0.01 | 1130 | 262 | <0.005 | 1.5 | 0.03 | 0.35 | 1.6 | 2 | 0.006 | 0.04 | 0.008 | 790 | 93 | 13 | 99 | 18 | 105 | 40
 | 2020-05-29 00:00:00 | 09:43:00 | 2 | 22.4 | 2 | 23.9 | 6.9 | 6770 | 4270 | 3.7 | 962 | 962 | <20 | <0.05 | <0.05 | 0.18 | 0.18 | <0.01 | <0.01 | <0.01 | <0.01 | 1680 | 141 | <0.005 | 1.2 | 0.03 | 0.19 | 1.3 | 1.7 | 0.008 | 0.06 | 0.007 | 810 | 150 | 8.5 | 200 | 5 | 90 | 39
 | 2020-05-29 00:00:00 | 09:06:00 | 3 | 21.6 | 5.7 | 66.8 | 7.1 | 4760 | 3040 | 2.5 | 1130 | 1130 | <20 | <0.05 | <0.05 | 0.19 | 0.19 | <0.01 | <0.01 | <0.01 | <0.01 | 879 | 147 | <0.005 | 0.0005 | 0.02 | 0.01 | 0.01 | 0.02 | 0.002 | 0.02 | <0.001 | 670 | 19 | 11 | 25 | <5 | 38 | 2.4
 | 2020-05-29 00:00:00 | 08:25:00 | 4 | 21 | 1.6 | 18.6 | 6.8 | 3020 | 1860 | 1.6 | 714 | 714 | <20 | <0.05 | <0.05 | 0.35 | 0.35 | <0.01 | <0.01 | <0.01 | <0.01 | 539 | 77.6 | <0.005 | 0.76 | 0.03 | 0.08 | 0.8 | 0.83 | 0.003 | 0.04 | <0.001 | 200 | 90 | 5.4 | 180 | <5 | 40 | 14
 | 2020-05-29 00:00:00 | 07:36:00 | 5 | 21.6 | 1.9 | 22.6 | 7 | 2560 | 1640 | 1.3 | 810 | 810 | <20 | <0.05 | 0.07 | 0.29 | 0.22 | <0.01 | 0.07 | <0.01 | 0.31 | 371 | 49.3 | <0.005 | 0.25 | 0.04 | 0.12 | 0.28 | 2.4 | 0.004 | 0.05 | 0.002 | 350 | 57 | 5.4 | 100 | <5 | 38 | 31
 | 2020-05-29 00:00:00 | 07:17:00 | 6 | 20.8 | 2.1 | 24.2 | 7.1 | 2310 | 1480 | 1.2 | 1120 | 1120 | <20 | 0.41 | <0.05 | 0.75 | 0.75 | <0.01 | <0.01 | <0.01 | <0.01 | 113 | 45.3 | <0.005 | 0.84 | 0.01 | 0.08 | 0.92 | 1.7 | 0.007 | 0.01 | <0.001 | 410 | 32 | 9.3 | 58 | <5 | 32 | 22
 | 2020-02-28 00:00:00 | 12:23:00 | 1 | 23.6 | 1.8 | 22.1 | 6.9 | 1810 | 3150 |  | 768 | 768 | <20 | 0.11 | 0.09 | 0.64 | 0.55 | 0.04 | 0.05 | 0.14 | 0.21 | 939 | 202 | 0.01 | 1.5 | 0.01 | 0.09 | 1.4 | 0.8 | 0.006 | 0.02 | 0.002 | 780 | 94 | 8 | 86 | <5 | 24 | 7.6
 | 2020-02-28 00:00:00 | 12:03:00 | 2 | 23.3 | 1.5 | 19 | 6.9 | 7080 | 4460 |  | 950 | 950 | <20 | <0.05 | <0.05 | 0.06 | 0.06 | <0.01 | <0.01 | <0.01 | <0.01 | 1790 | 168 | 0.01 | 1.3 | 0.2 | 0.01 | 1.3 | 1.1 | <0.001 | 0.2 | <0.001 | 1030 | 190 | 5.5 | 230 | <5 | 64 | 4.4
 | 2020-02-28 00:00:00 | 10:02:00 | 3 | 22.2 | 5.5 | 66.3 | 7 | 4950 | 3170 |  | 1130 | 1130 | <20 | <0.05 | <0.05 | 0.17 | 0.17 | <0.01 | <0.01 | <0.01 | <0.01 | 912 | 150 | 0.01 | 0.001 | 0.02 | 0.01 | 0.02 | 0.01 | 0.002 | 0.02 | <0.001 | 790 | 110 | 7.7 | 140 | <5 | 45 | 2.4
 | 2020-02-28 00:00:00 | 10:42:00 | 4 | 22.8 | 2.9 | 34.2 | 6.8 | 1390 | 969 |  | 705 | 705 | <20 | 0.05 | <0.05 | 0.13 | 0.13 | <0.01 | <0.01 | <0.01 | <0.01 | 567 | 78.2 | 0.01 | 0.84 | 0.02 | 0.03 | 0.84 | 0.4 | 0.002 | 0.01 | <0.001 | 300 | 96 | 3.9 | 200 | <5 | 6 | 6.3
 | 2020-02-28 00:00:00 | 11:33:00 | 5 | 22.7 | 1.4 | 17 | 7 | 2510 | 1640 |  | 778 | 778 | <20 | <0.05 | <0.05 | 0.08 | 0.08 | <0.01 | <0.01 | <0.01 | <0.01 | 366 | 47.6 | 0.01 | 0.23 | 0.005 | 0.04 | 0.23 | 2.1 | 0.001 | 0.006 | <0.001 | 330 | 63 | 3.6 | 120 | <5 | 16 | 11
 | 2020-02-28 00:00:00 | 11:13:00 | 6 | 23.4 | 1.6 | 19.9 | 7.1 | 2430 | 1560 |  | 1150 | 1150 | <20 | 0.32 | <0.05 | 0.67 | 0.67 | <0.01 | <0.01 | <0.01 | <0.01 | 119 | 47.6 | 0.01 | 1.1 | 0.01 | 0.09 | 1.1 | 1.8 | 0.02 | 0.02 | <0.001 | 470 | 39 | 8 | 59 | <5 | 16 | 20