Spreadsheet: 786602d1657294161-vlookup-using-multiple-search-criteria-example
Sheet: DATA1

Borehole | Sample Top Depth | Sample [NAME] | Classification
 | [m] | [m]
NSPT-01 | 1.5 | 1.5 | ???
NSPT-01 | 3 | 3.8
NSPT-01 | 4.5 | 4.5
NSPT-01 | 6 | 6.8
NSPT-01 | 7.5 | 7.5
NSPT-01 | 9 | 9.8
NSPT-01 | 10.5 | 10.5
NSPT-01 | 12 | 13.5
NSPT-01 | 13.5 | 13.5
NSPT-01 | 15 | 15.8
NSPT-01 | 16.5 | 16.5
NSPT-01 | 18 | 18.8
NSPT-01 | 19.5 | 19.5
NSPT-01 | 21 | 21.8
NSPT-01 | 22.5 | 22.5
NSPT-01 | 24 | 24.8
NSPT-01 | 25.5 | 25.5
NSPT-01 | 27 | 27.8
NSPT-01 | 30 | 30.8
NSPT-01 | 33 | 33.8
NSPT-01 | 36.5 | 37.5
NSPT-01 | 39 | 39
NSPT-01 | 42 | 42
NSPT-01 | 44 | 45
NSPT-01 | 48 | 48
NSPT-01 | 51 | 51
NSPT-01 | 54 | 54
NSPT-01 | 57 | 57
NSPT-01 | 60 | 60
NSPT-01 | 66 | 66
NSPT-01 | 70.5 | 70.5
NSPT-01 | 75 | 75
NSPT-01 | 81 | 81
NSPT-01 | 84 | 84
NSPT-02 | 3 | 3.8
NSPT-02 | 4.5 | 4.5
NSPT-02 | 6 | 6.8
NSPT-02 | 7.5 | 7.5
NSPT-02 | 9 | 9.8
NSPT-02 | 10.5 | 10.5
NSPT-02 | 12 | 13.5
NSPT-02 | 15 | 15
NSPT-02 | 16.5 | 16.5
NSPT-02 | 18 | 18
NSPT-02 | 19.5 | 19.5
NSPT-02 | 21 | 21
NSPT-02 | 22.5 | 22.5
NSPT-02 | 24 | 24
NSPT-02 | 25.5 | 25.5
NSPT-02 | 27 | 27.8
NSPT-02 | 28.5 | 28.5
NSPT-02 | 30 | 30.8
NSPT-02 | 33 | 33
NSPT-02 | 34.5 | 35.3
NSPT-02 | 37.5 | 37.5
NSPT-02 | 40.5 | 41.3
NSPT-02 | 43.5 | 43.5
NSPT-02 | 49.5 | 51
NSPT-02 | 52.5 | 52.5
NSPT-02 | 55.5 | 55.5
NSPT-02 | 58.5 | 58.5
NSPT-02 | 61.5 | 61.5
NSPT-02 | 64.5 | 64.5
NSPT-02 | 67.5 | 67.5
NSPT-02 | 70.5 | 70.5
NSPT-02 | 73.5 | 73.5
NSPT-02 | 76.5 | 76.5
NSPT-02 | 79.5 | 79.5
NSPT-02 | 82.5 | 82.5
NSPT-02 | 85.5 | 85.5
NSPT-02 | 88.5 | 88.5
NSPT-03 | 1.5 | 2.3
NSPT-03 | 3 | 3
NSPT-03 | 4.5 | 5.3
NSPT-03 | 6 | 6
NSPT-03 | 7.5 | 8.3
NSPT-03 | 9 | 9
NSPT-03 | 10.5 | 11.3
NSPT-03 | 12 | 12
NSPT-03 | 13.5 | 14.3
NSPT-03 | 15 | 15
NSPT-03 | 16.5 | 17.3
NSPT-03 | 18 | 19.5
NSPT-03 | 21 | 21
NSPT-03 | 22.5 | 22.5
NSPT-03 | 25.5 | 26.3
NSPT-03 | 27 | 27
NSPT-03 | 28.5 | 29.3
NSPT-03 | 31.5 | 31.5
NSPT-03 | 33 | 33
NSPT-03 | 37.5 | 37.5
NSPT-03 | 39 | 39
NSPT-03 | 43.5 | 43.5
NSPT-03 | 45 | 45
NSPT-03 | 48 | 51
NSPT-03 | 52.5 | 52.5
NSPT-03 | 55.5 | 55.5
NSPT-03 | 57 | 57
NSPT-03 | 60 | 60
NSPT-03 | 63 | 63
NSPT-03 | 66 | 66
NSPT-03 | 69 | 69
NSPT-03 | 72 | 72
NSPT-03 | 75 | 75
NSPT-04 | 0 | 0
NSPT-04 | 1.5 | 2.3
NSPT-04 | 3 | 3
NSPT-04 | 4.5 | 5.3
NSPT-04 | 6 | 6
NSPT-04 | 7 | 8.3
NSPT-04 | 9 | 9
NSPT-04 | 10.5 | 10.5
NSPT-04 | 12 | 12
NSPT-04 | 12.5 | 13.5
NSPT-04 | 15 | 15
NSPT-04 | 18 | 18
NSPT-04 | 21 | 21.8
NSPT-04 | 24 | 24
NSPT-04 | 27 | 27.8
NSPT-04 | 28.5 | 28.5
NSPT-04 | 30 | 30.8
NSPT-04 | 31.5 | 31.5
NSPT-04 | 33 | 3.3
NSPT-04 | 33 | 3.4
NSPT-04 | 34.5 | 34.5
NSPT-04 | 36.5 | 37.5
NSPT-04 | 39 | 39
NSPT-04 | 42 | 42
NSPT-04 | 45 | 45
NSPT-04 | 47 | 48
NSPT-04 | 51 | 51
NSPT-04 | 54 | 54
NSPT-04 | 57 | 57
NSPT-04 | 60 | 60
NSPT-04 | 63 | 63
NSPT-04 | 66 | 66
NSPT-04 | 69 | 69
NSPT-05 | 0 | 0
NSPT-05 | 1.5 | 1.5
NSPT-05 | 3 | 3.8
NSPT-05 | 4.5 | 4.5
NSPT-05 | 6 | 6.8
NSPT-05 | 4.5 | 7.5
NSPT-05 | 9 | 9.8
NSPT-05 | 10.5 | 10.5
NSPT-05 | 12 | 12.8
NSPT-05 | 13.5 | 13.5
NSPT-05 | 15 | 16.5
NSPT-05 | 18 | 18.8
NSPT-05 | 19.5 | 19.5
NSPT-05 | 21 | 21.8
NSPT-05 | 22.5 | 22.5
NSPT-05 | 24 | 24.8
NSPT-05 | 25.5 | 25.5
NSPT-05 | 27 | 27.8
NSPT-05 | 28.5 | 28.5
NSPT-05 | 30 | 30.8
NSPT-05 | 31.5 | 31.5
NSPT-05 | 33 | 33
NSPT-05 | 35 | 35.8
NSPT-05 | 36 | 36
NSPT-05 | 37.5 | 37.5
NSPT-05 | 39.5 | 40.5
NSPT-05 | 42 | 42
NSPT-05 | 45 | 45
NSPT-05 | 48 | 48
NSPT-05 | 51 | 51
NSPT-05 | 54 | 54
NSPT-05 | 57 | 57
NSPT-05 | 60 | 60
NSPT-05 | 63 | 63
NSPT-06 | 1.5 | 1.5
NSPT-06 | 3 | 3.8
NSPT-06 | 4.5 | 4.5
NSPT-06 | 6 | 6.8
NSPT-06 | 7.5 | 7.5
NSPT-06 | 9 | 9.8
NSPT-06 | 10.5 | 10.5
NSPT-06 | 12 | 12.8
NSPT-06 | 15.5 | 16.5
NSPT-06 | 18 | 18
NSPT-06 | 21 | 21
NSPT-06 | 22.5 | 22.5
NSPT-06 | 24 | 24.8
NSPT-06 | 27 | 27.8
NSPT-06 | 30 | 30
NSPT-06 | 33 | 33
NSPT-06 | 36 | 36.8
NSPT-06 | 39 | 39.8
NSPT-06 | 42 | 42.8
NSPT-06 | 45.5 | 46.5
NSPT-06 | 48 | 48
NSPT-06 | 51 | 51
NSPT-06 | 54 | 54
NSPT-06 | 57 | 57
NSPT-06 | 60 | 60
NSPT-06 | 64.5 | 64.5
NSPT-06 | 70.5 | 70.5
NSPT-06 | 75 | 75
NSPT-06 | 78 | 78
NSPT-07 | 1.5 | 1.5
NSPT-07 | 2.5 | 3.3
NSPT-07 | 4.5 | 4.5
NSPT-07 | 5.5 | 6.3
NSPT-07 | 7.5 | 7.5
NSPT-07 | 8.5 | 9.3
NSPT-07 | 10.5 | 10.5
NSPT-07 | 11.5 | 12.3
NSPT-07 | 13.5 | 13.5
NSPT-07 | 14.5 | 15.3
NSPT-07 | 16.5 | 16.5
NSPT-07 | 17.5 | 7.6
NSPT-07 | 17.5 | 7.9
NSPT-07 | 19.5 | 19.5
NSPT-07 | 21 | 21
NSPT-07 | 21 | 22.5
NSPT-07 | 22.5 | 22.5
NSPT-07 | 23.5 | 24.3
NSPT-07 | 25.5 | 25.5
NSPT-07 | 26.5 | 27.3
NSPT-07 | 28.5 | 28.5
NSPT-07 | 29.5 | 32.3
NSPT-07 | 31.5 | 31.5
NSPT-07 | 33 | 33
NSPT-07 | 34.5 | 4.5
NSPT-07 | 34.5 | 5
NSPT-07 | 37.5 | 37.5
NSPT-07 | 40.5 | 41.3
NSPT-07 | 42 | 42
NSPT-07 | 46.5 | 48
NSPT-07 | 48 | 48
NSPT-07 | 51 | 51
NSPT-07 | 55.5 | 55.5
NSPT-07 | 60 | 60
NSPT-07 | 64.5 | 66.5
NSPT-07 | 70.5 | 70.5
NSPT-07 | 75 | 75
NSPT-08 | 1.5 | 1.5
NSPT-08 | 3 | 3.8
NSPT-08 | 4.5 | 4.5
NSPT-08 | 6 | 6.8
NSPT-08 | 7.5 | 7.5
NSPT-08 | 9 | 9.8
NSPT-08 | 10.5 | 10.5
NSPT-08 | 12 | 2.4
NSPT-08 | 12 | 2.7
NSPT-08 | 13.5 | 13.5
NSPT-08 | 15 | 5.2
NSPT-08 | 15 | 5.5
NSPT-08 | 16.5 | 16.5
NSPT-08 | 18 | 18.8
NSPT-08 | 19.5 | 19.5
NSPT-08 | 21 | 21.8
NSPT-08 | 22.5 | 22.5
NSPT-08 | 24 | 24.8
NSPT-08 | 25.5 | 25.5
NSPT-08 | 27 | 27.8
NSPT-08 | 28.5 | 28.5
NSPT-08 | 30 | 30.8
NSPT-08 | 33 | 33
NSPT-08 | 34.5 | 35.3
NSPT-08 | 36 | 36
NSPT-08 | 39 | 39.8
NSPT-08 | 42 | 42
NSPT-08 | 45 | 46
NSPT-08 | 48 | 48
NSPT-08 | 51 | 51
NSPT-08 | 53 | 54
NSPT-08 | 57 | 57.8
NSPT-08 | 61.5 | 61.5
NSPT-08 | 63 | 63
NSPT-08 | 64.5 | 64.5
NSPT-08 | 69 | 69
NSPT-08 | 75 | 75
NSPT-08 | 79.5 | 79.5
NSPT-09 | 1 | 1.8
NSPT-09 | 3 | 3
NSPT-09 | 4 | 4.8
NSPT-09 | 6 | 6
NSPT-09 | 7 | 7.8
NSPT-09 | 9 | 9
NSPT-09 | 10 | 10.8
NSPT-09 | 12 | 12
NSPT-09 | 13 | 13.8
NSPT-09 | 15 | 15
NSPT-09 | 16 | 16.8
NSPT-09 | 18 | 18
NSPT-09 | 19 | 19.8
NSPT-09 | 21 | 21
NSPT-09 | 22 | 22.8
NSPT-09 | 24 | 24
NSPT-09 | 25 | 25.8
NSPT-09 | 27 | 27
NSPT-09 | 28 | 28.8
NSPT-09 | 30 | 30
NSPT-09 | 31 | 31.8
NSPT-09 | 33 | 33
NSPT-09 | 34 | 36
NSPT-09 | 37.5 | 37.5
NSPT-09 | 40 | 40.8
NSPT-09 | 43.5 | 43.5
NSPT-09 | 45 | 46.5
NSPT-09 | 48 | 48
NSPT-09 | 51 | 51
NSPT-09 | 54 | 54
NSPT-09 | 57 | 57
NSPT-09 | 60 | 60
NSPT-09 | 64.5 | 64.5
NSPT-09 | 69 | 69
NSPT-09 | 75 | 75
NSPT-09 | 81 | 81
NSPT-10 | 1.5 | 1.5
NSPT-10 | 3 | 3
NSPT-10 | 4.5 | 4.5
NSPT-10 | 5 | 6
NSPT-10 | 7.5 | 7.5
NSPT-10 | 10.5 | 10.5
NSPT-10 | 12 | 12
NSPT-10 | 13.5 | 14.3
NSPT-10 | 16.5 | 16.5
NSPT-10 | 19.5 | 19.5
NSPT-10 | 21 | 21
NSPT-10 | 22.5 | 23.3
NSPT-10 | 25.5 | 26.3
NSPT-10 | 28.5 | 29.3
NSPT-10 | 31.5 | 32.3
NSPT-10 | 34.5 | 34.5
NSPT-10 | 35 | 36
NSPT-10 | 37.5 | 37.5
NSPT-10 | 40.5 | 40.5
NSPT-10 | 43.5 | 43.5
NSPT-10 | 45 | 45
NSPT-10 | 46.5 | 46.5
NSPT-10 | 48 | 48.8
NSPT-10 | 49.5 | 49.5
NSPT-10 | 51 | 51.8
NSPT-10 | 52.5 | 52.5
NSPT-10 | 55 | 55
NSPT-10 | 58.5 | 58.5
NSPT-10 | 61.5 | 61.5
NSPT-10 | 64.5 | 64.5
NSPT-10 | 67.5 | 67.5
NSPT-10 | 70.5 | 70.5
NSPT-10 | 73.5 | 73.5
NSPT-11 | 1.5 | 1.5
NSPT-11 | 3 | 3.8
NSPT-11 | 4.5 | 4.5
NSPT-11 | 6 | 6
NSPT-11 | 7.5 | 7.5
NSPT-11 | 9.0~ | 9.8
NSPT-11 | 10.5 | 10.5
NSPT-11 | 12 | 12.8
NSPT-11 | 13.5 | 13.5
NSPT-11 | 15 | 15.8
NSPT-11 | 16.5 | 16.5
NSPT-11 | 18 | 18.8
NSPT-11 | 19.5 | 19.5
NSPT-11 | 21 | 21.8
NSPT-11 | 22.5 | 22.5
NSPT-11 | 24 | 24.8
NSPT-11 | 25.5 | 25.5
NSPT-11 | 27 | 27.8
NSPT-11 | 30 | 30
NSPT-11 | 33 | 33
NSPT-11 | 35 | 36
NSPT-11 | 39 | 39
NSPT-11 | 42 | 42
NSPT-11 | 45 | 45
NSPT-11 | 47 | 48
NSPT-11 | 49.5 | 50.3
NSPT-11 | 51 | 51
NSPT-11 | 52.5 | 53.3
NSPT-11 | 54 | 54
NSPT-11 | 57 | 57
NSPT-11 | 60 | 60
NSPT-11 | 64.5 | 64.5
NSPT-11 | 70.5 | 70.5
NSPT-11 | 78 | 78
NSPT-12 | 1.5 | 1.5
NSPT-12 | 3 | 3.8
NSPT-12 | 4.5 | 4.5
NSPT-12 | 6 | 6.8
NSPT-12 | 7.5 | 7.5
NSPT-12 | 9 | 9.8
NSPT-12 | 10.5 | 10.5
NSPT-12 | 12 | 13.5
NSPT-12 | 13.5 | 13.5
NSPT-12 | 15 | 15.8
NSPT-12 | 16.5 | 16.5
NSPT-12 | 18 | 18.8
NSPT-12 | 19.5 | 19.5
NSPT-12 | 21 | 21.8
NSPT-12 | 22.5 | 22.5
NSPT-12 | 24 | 24.8
NSPT-12 | 27 | 27.8
NSPT-12 | 30 | 30.8
NSPT-12 | 33 | 33
NSPT-12 | 35 | 36
NSPT-12 | 37.5 | 37.5
NSPT-12 | 40.5 | 40.5
NSPT-12 | 43.5 | 43.5
NSPT-12 | 46.5 | 46.5
NSPT-12 | 49.5 | 49.5
NSPT-12 | 52.5 | 52.5
NSPT-12 | 56 | 57
NSPT-12 | 61.5 | 61.5
NSPT-12 | 66 | 66
NSPT-12 | 70.5 | 70.5
NSPT-12 | 75 | 75
NSPT-12 | 79.5 | 79.5
NSPT-12 | 84 | 84
NSPT-12 | 87 | 87