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

Borehole | Top | Bottom | Classification (SPT)
NSPT-01 | 1.3 | 35 | Silty Clay
NSPT-01 | 35 | 58 | Silty Sand
NSPT-01 | 58 | 68 | Sand with silt
NSPT-01 | 68 | 80.5 | Sand
NSPT-01 | 80.5 | 82.5 | [NAME] with Silt
NSPT-02 | 1.9 | 10 | Silty Clay
NSPT-02 | 10 | 20 | Silty Sand with Clay
NSPT-02 | 20 | 26.5 | [NAME] with Sand
NSPT-02 | 26.5 | 42.2 | Silty Clay
NSPT-02 | 42.2 | 44 | Silty Sand
NSPT-02 | 44 | 48.2 | [NAME]
NSPT-02 | 48.2 | 60.2 | Silty Sand
NSPT-02 | 60.2 | 74.3 | Sand
NSPT-02 | 74.3 | 81 | [NAME]
NSPT-02 | 81 | 91.3 | Silty Sand
NSPT-03 | 2.3 | 6.5 | Clay with Sand
NSPT-03 | 16.5 | 21 | Silty Sand
NSPT-03 | 21 | 44.3 | Silty Clay with Sand
NSPT-03 | 44.3 | 47.1 | Silty Sand
NSPT-03 | 47.1 | 56.8 | Silty Sand with Gravel
NSPT-03 | 56.8 | 62.8 | Silty Sand
NSPT-03 | 62.8 | 70.5 | Silty Sand
NSPT-03 | 70.5 | 76 | Gravel with Sand
NSPT-04 | 1 | 4 | Clay
NSPT-04 | 4 | 10.3 | Silt
NSPT-04 | 10.3 | 25 | Silty Sand
NSPT-04 | 25 | 34 | [NAME]
NSPT-04 | 34 | 52 | Silty Sand
NSPT-04 | 52 | 58 | Sand with Silt
NSPT-04 | 58 | 64 | Silty Sand
NSPT-04 | 64 | 68 | [NAME]
NSPT-04 | 68 | 70 | Weathered Rock
NSPT-05 | 1.4 | 7 | Clay
NSPT-05 | 7 | 16.7 | [NAME] with Sand
NSPT-05 | 16.7 | 28.4 | Silty Clay with Sand
NSPT-05 | 28.4 | 36.5 | [NAME] with Sand
NSPT-05 | 36.5 | 53.7 | Silty Sand
NSPT-05 | 53.7 | 57.6 | [NAME] with Clay
NSPT-05 | 57.6 | 62 | [NAME] with Silt
NSPT-05 | 62 | 62.6 | Weathered Rock
NSPT-06 | 1.3 | 13 | Clay
NSPT-06 | 13 | 23.5 | Silty Sand
NSPT-06 | 23.5 | 32 | Silty Sand
NSPT-06 | 32 | 36 | [NAME] with clay
NSPT-06 | 36 | 44.5 | Silty Sand
NSPT-06 | 44.5 | 62 | Silty Sand
NSPT-06 | 62 | 68 | [NAME] with clay
NSPT-06 | 68 | 74 | Sand with gravel
NSPT-06 | 74 | 76.5 | [NAME] with clay
NSPT-06 | 76.5 | 77.6 | Weathered Rock
NSPT-07 | 0.8 | 17.4 | Clay with Silt
NSPT-07 | 17 | 23 | [NAME] with Sand
NSPT-07 | 23 | 35.5 | Clay with Sand
NSPT-07 | 35.5 | 46 | Clay
NSPT-07 | 46 | 52.1 | Silty Sand
NSPT-07 | 52.1 | 55.5 | Clay
NSPT-07 | 55.5 | 64.3 | Silty sand with gravel
NSPT-07 | 64.3 | 73.2 | Silty sand with gravel
NSPT-07 | 73.2 | 77.8 | Weathered soil
NSPT-08 | 1.5 | 13.5 | Clay
NSPT-08 | 13 | 22 | Silt
NSPT-08 | 22 | 40.5 | Clay
NSPT-08 | 40.5 | 55 | Silty Sand
NSPT-08 | 55 | 61 | Clay
NSPT-08 | 61 | 63.5 | Sand
NSPT-08 | 63.5 | 80.2 | Weathered soil
NSPT-09 | 1.8 | 33 | Clay with sand
NSPT-09 | 33 | 38.5 | Silty sand
NSPT-09 | 38.5 | 41.2 | Clay
NSPT-09 | 41.2 | 49.7 | Silty sand
NSPT-09 | 49.7 | 53.2 | Clayey sand
NSPT-09 | 53.2 | 71.3 | Silty sand
NSPT-09 | 71.3 | 74.3 | Clay with Sand
NSPT-10 | 1 | 13 | Sandy silt with clay
NSPT-10 | 13 | 18 | Sand with Silt
NSPT-10 | 18 | 20.5 | Sandy silt
NSPT-10 | 20.5 | 33.5 | Clay
NSPT-10 | 33.5 | 46 | Silty sand
NSPT-10 | 46 | 52 | Clay with silt
NSPT-10 | 52 | 65 | Silty sand
NSPT-10 | 65 | 69 | Silty gravel
NSPT-10 | 69 | 73 | Silty sand
NSPT-10 | 73 | 73.5 | Weathered rock
NSPT-11 | 0.6 | 8.5 | Clayey silt
NSPT-11 | 8.5 | 29.5 | Clay
NSPT-11 | 29.5 | 48 | Silty Sand
NSPT-11 | 48 | 53.5 | Silty Clay
NSPT-11 | 53.5 | 67 | Silty Sand
NSPT-11 | 67 | 78 | Sandy gravel with silt
NSPT-11 | 78 | 78.8 | Clayey sand
NSPT-12 | 1.7 | 32.5 | Silty Clay
NSPT-12 | 32 | 52.7 | Silty Sand with Clay
NSPT-12 | 52.7 | 59 | Sand with silt
NSPT-12 | 59 | 85 | Clay
NSPT-12 | 85 | 86.2 | Weathered rock