Spreadsheet: 740546d1626369861-vlookup-where-lookout-values-are-between-2-columns-2vlookup
Sheet: Calculation

 | (Area)Location | Group | (Area2)Location2 |  | (Area2)Location2 | Group | (Area)Location |  |  | (Area)Location | (Area2)Location2 | Group
 | (1)1 | 1 | (1)A1 |  | (1)A1 | 1 | (1)1
 | (1)2 | 2 | (1)A2 |  | (1)A2 | 2 | (1)2
 | (1)3 | 3 | (1)A3 |  | (1)A3 | 3 | (1)3
 | (1)4 | 4 | (1)A4 |  | (1)A4 | 4 | (1)4
 | (1)5 | 5 | (1)A5 |  | (1)A5 | 5 | (1)5
 | (1)6 | 6 | (1)A6 |  | (1)A6 | 6 | (1)6
 | (1)7 | 7 | (1)A7 |  | (1)A7 | 7 | (1)7
 | (1)8 | 8 | (1)A8 |  | (1)A8 | 8 | (1)8
 | (1)9 | 1 | (1)A9 |  | (1)A9 | 1 | (1)9
 | (1)10 | 2 | (1)A10 |  | (1)A10 | 2 | (1)10
 | (1)11 | 3 | (1)A11 |  | (1)A11 | 3 | (1)11
 | (1)12 | 4 | (1)A12 |  | (1)A12 | 4 | (1)12
 | (1)13 | 5 | (1)B1 |  | (1)B1 | 5 | (1)13
 | (1)14 | 6 | (1)B2 |  | (1)B2 | 6 | (1)14
 | (1)15 | 7 | (1)B3 |  | (1)B3 | 7 | (1)15
 | (1)16 | 8 | (1)B4 |  | (1)B4 | 8 | (1)16
 | (2)1 | 1 | (1)B5 |  | (1)B5 | 1 | (2)1
 | (2)2 | 2 | (1)B6 |  | (1)B6 | 2 | (2)2
 | (2)3 | 3 | (1)B7 |  | (1)B7 | 3 | (2)3
 | (2)4 | 4 | (1)B8 |  | (1)B8 | 4 | (2)4
 | (2)5 | 5 | (1)B9 |  | (1)B9 | 5 | (2)5
 | (2)6 | 6 | (1)B10 |  | (1)B10 | 6 | (2)6
 | (2)7 | 7 | (1)B11 |  | (1)B11 | 7 | (2)7
 | (2)8 | 8 | (1)B12 |  | (1)B12 | 8 | (2)8
 | (2)9 | 1 | (1)C1 |  | (1)C1 | 1 | (2)9
 | (2)10 | 2 | (1)C2 |  | (1)C2 | 2 | (2)10
 | (2)11 | 3 | (1)C3 |  | (1)C3 | 3 | (2)11
 | (2)12 | 4 | (1)C4 |  | (1)C4 | 4 | (2)12
 | (2)13 | 5 | (1)C5 |  | (1)C5 | 5 | (2)13
 | (2)14 | 6 | (1)C6 |  | (1)C6 | 6 | (2)14
 | (2)15 | 7 | (1)C7 |  | (1)C7 | 7 | (2)15
 | (2)16 | 8 | (1)C8 |  | (1)C8 | 8 | (2)16
 | (3)1 | 1 | (1)C9 |  | (1)C9 | 1 | (3)1
 | (3)2 | 2 | (1)C10 |  | (1)C10 | 2 | (3)2
 | (3)3 | 3 | (1)C11 |  | (1)C11 | 3 | (3)3
 | (3)4 | 4 | (1)C12 |  | (1)C12 | 4 | (3)4
 | (3)5 | 5 | (1)D1 |  | (1)D1 | 5 | (3)5
 | (3)6 | 6 | (1)D2 |  | (1)D2 | 6 | (3)6
 | (3)7 | 7 | (1)D3 |  | (1)D3 | 7 | (3)7
 | (3)8 | 8 | (1)D4 |  | (1)D4 | 8 | (3)8
 | (3)9 | 1 | (1)D5 |  | (1)D5 | 1 | (3)9
 | (3)10 | 2 | (1)D6 |  | (1)D6 | 2 | (3)10
 | (3)11 | 3 | (1)D7 |  | (1)D7 | 3 | (3)11
 | (3)12 | 4 | (1)D8 |  | (1)D8 | 4 | (3)12
 | (3)13 | 5 | (1)D9 |  | (1)D9 | 5 | (3)13
 | (3)14 | 6 | (1)D10 |  | (1)D10 | 6 | (3)14
 | (3)15 | 7 | (1)D11 |  | (1)D11 | 7 | (3)15
 | (3)16 | 8 | (1)D12 |  | (1)D12 | 8 | (3)16
 | (4)1 | 1 | (1)E1 |  | (1)E1 | 1 | (4)1
 | (4)2 | 2 | (1)E2 |  | (1)E2 | 2 | (4)2
 | (4)3 | 3 | (1)E3 |  | (1)E3 | 3 | (4)3
 | (4)4 | 4 | (1)E4 |  | (1)E4 | 4 | (4)4
 | (4)5 | 5 | (1)E5 |  | (1)E5 | 5 | (4)5
 | (4)6 | 6 | (1)E6 |  | (1)E6 | 6 | (4)6
 | (4)7 | 7 | (1)E7 |  | (1)E7 | 7 | (4)7
 | (4)8 | 8 | (1)E8 |  | (1)E8 | 8 | (4)8
 | (4)9 | 1 | (1)E9 |  | (1)E9 | 1 | (4)9
 | (4)10 | 2 | (1)E10 |  | (1)E10 | 2 | (4)10
 | (4)11 | 3 | (1)E11 |  | (1)E11 | 3 | (4)11
 | (4)12 | 4 | (1)E12 |  | (1)E12 | 4 | (4)12
 | (4)13 | 5 | (1)F1 |  | (1)F1 | 5 | (4)13
 | (4)14 | 6 | (1)F2 |  | (1)F2 | 6 | (4)14
 | (4)15 | 7 | (1)F3 |  | (1)F3 | 7 | (4)15
 | (4)16 | 8 | (1)F4 |  | (1)F4 | 8 | (4)16
 | (5)1 | 1 | (1)F5 |  | (1)F5 | 1 | (5)1
 | (5)2 | 2 | (1)F6 |  | (1)F6 | 2 | (5)2
 | (5)3 | 3 | (1)F7 |  | (1)F7 | 3 | (5)3
 | (5)4 | 4 | (1)F8 |  | (1)F8 | 4 | (5)4
 | (5)5 | 5 | (1)F9 |  | (1)F9 | 5 | (5)5
 | (5)6 | 6 | (1)F10 |  | (1)F10 | 6 | (5)6
 | (5)7 | 7 | (1)F11 |  | (1)F11 | 7 | (5)7
 | (5)8 | 8 | (1)F12 |  | (1)F12 | 8 | (5)8
 | (5)9 | 1 | (1)G1 |  | (1)G1 | 1 | (5)9
 | (5)10 | 2 | (1)G2 |  | (1)G2 | 2 | (5)10
 | (5)11 | 3 | (1)G3 |  | (1)G3 | 3 | (5)11
 | (5)12 | 4 | (1)G4 |  | (1)G4 | 4 | (5)12
 | (5)13 | 5 | (1)G5 |  | (1)G5 | 5 | (5)13
 | (5)14 | 6 | (1)G6 |  | (1)G6 | 6 | (5)14
 | (5)15 | 7 | (1)G7 |  | (1)G7 | 7 | (5)15
 | (5)16 | 8 | (1)G8 |  | (1)G8 | 8 | (5)16
 | (6)1 | 1 | (1)G9 |  | (1)G9 | 1 | (6)1
 | (6)2 | 2 | (1)G10 |  | (1)G10 | 2 | (6)2
 | (6)3 | 3 | (1)G11 |  | (1)G11 | 3 | (6)3
 | (6)4 | 4 | (1)G12 |  | (1)G12 | 4 | (6)4
 | (6)5 | 5 | (1)H1 |  | (1)H1 | 5 | (6)5
 | (6)6 | 6 | (1)H2 |  | (1)H2 | 6 | (6)6
 | (6)7 | 7 | (1)H3 |  | (1)H3 | 7 | (6)7
 | (6)8 | 8 | (1)H4 |  | (1)H4 | 8 | (6)8
 | (6)9 | 1 | (1)H5 |  | (1)H5 | 1 | (6)9
 | (6)10 | 2 | (1)H6 |  | (1)H6 | 2 | (6)10
 | (6)11 | 3 | (1)H7 |  | (1)H7 | 3 | (6)11
 | (6)12 | 4 | (1)H8 |  | (1)H8 | 4 | (6)12
 | (6)13 | 5 | (1)H9 |  | (1)H9 | 5 | (6)13
 | (6)14 | 6 | (1)H10 |  | (1)H10 | 6 | (6)14
 | (6)15 | 7 | (2)A1 |  | (2)A1 | 7 | (6)15
 | (6)16 | 8 | (2)A2 |  | (2)A2 | 8 | (6)16
 | (7)1 | 1 | (2)A3 |  | (2)A3 | 1 | (7)1
 | (7)2 | 2 | (2)A4 |  | (2)A4 | 2 | (7)2
 | (7)3 | 3 | (2)A5 |  | (2)A5 | 3 | (7)3
 | (7)4 | 4 | (2)A6 |  | (2)A6 | 4 | (7)4
 | (7)5 | 5 | (2)A7 |  | (2)A7 | 5 | (7)5
 | (7)6 | 6 | (2)A8 |  | (2)A8 | 6 | (7)6
 | (7)7 | 7 | (2)A9 |  | (2)A9 | 7 | (7)7
 | (7)8 | 8 | (2)A10 |  | (2)A10 | 8 | (7)8
 | (7)9 | 1 | (2)A11 |  | (2)A11 | 1 | (7)9
 | (7)10 | 2 | (2)A12 |  | (2)A12 | 2 | (7)10
 | (7)11 | 3 | (2)B1 |  | (2)B1 | 3 | (7)11
 | (7)12 | 4 | (2)B2 |  | (2)B2 | 4 | (7)12
 | (7)13 | 5 | (2)B3 |  | (2)B3 | 5 | (7)13
 | (7)14 | 6 | (2)B4 |  | (2)B4 | 6 | (7)14
 | (7)15 | 7 | (2)B5 |  | (2)B5 | 7 | (7)15
 | (7)16 | 8 | (2)B6 |  | (2)B6 | 8 | (7)16
 | (8)1 | 1 | (2)B7 |  | (2)B7 | 1 | (8)1
 | (8)2 | 2 | (2)B8 |  | (2)B8 | 2 | (8)2
 | (8)3 | 3 | (2)B9 |  | (2)B9 | 3 | (8)3
 | (8)4 | 4 | (2)B10 |  | (2)B10 | 4 | (8)4
 | (8)5 | 5 | (2)B11 |  | (2)B11 | 5 | (8)5
 | (8)6 | 6 | (2)B12 |  | (2)B12 | 6 | (8)6
 | (8)7 | 7 | (2)C1 |  | (2)C1 | 7 | (8)7
 | (8)8 | 8 | (2)C2 |  | (2)C2 | 8 | (8)8
 | (8)9 | 1 | (2)C3 |  | (2)C3 | 1 | (8)9
 | (8)10 | 2 | (2)C4 |  | (2)C4 | 2 | (8)10
 | (8)11 | 3 | (2)C5 |  | (2)C5 | 3 | (8)11
 | (8)12 | 4 | (2)C6 |  | (2)C6 | 4 | (8)12
 | (8)13 | 5 | (2)C7 |  | (2)C7 | 5 | (8)13
 | (8)14 | 6 | (2)C8 |  | (2)C8 | 6 | (8)14
 | (8)15 | 7 | (2)C9 |  | (2)C9 | 7 | (8)15
 | (8)16 | 8 | (2)C10 |  | (2)C10 | 8 | (8)16
 | (9)1 | 1 | (2)C11 |  | (2)C11 | 1 | (9)1
 | (9)2 | 2 | (2)C12 |  | (2)C12 | 2 | (9)2
 | (9)3 | 3 | (2)D1 |  | (2)D1 | 3 | (9)3
 | (9)4 | 4 | (2)D2 |  | (2)D2 | 4 | (9)4
 | (9)5 | 5 | (2)D3 |  | (2)D3 | 5 | (9)5
 | (9)6 | 6 | (2)D4 |  | (2)D4 | 6 | (9)6
 | (9)7 | 7 | (2)D5 |  | (2)D5 | 7 | (9)7
 | (9)8 | 8 | (2)D6 |  | (2)D6 | 8 | (9)8
 | (9)9 | 1 | (2)D7 |  | (2)D7 | 1 | (9)9
 | (9)10 | 2 | (2)D8 |  | (2)D8 | 2 | (9)10
 | (9)11 | 3 | (2)D9 |  | (2)D9 | 3 | (9)11
 | (9)12 | 4 | (2)D10 |  | (2)D10 | 4 | (9)12
 | (9)13 | 5 | (2)D11 |  | (2)D11 | 5 | (9)13
 | (9)14 | 6 | (2)D12 |  | (2)D12 | 6 | (9)14
 | (9)15 | 7 | (2)E1 |  | (2)E1 | 7 | (9)15
 | (9)16 | 8 | (2)E2 |  | (2)E2 | 8 | (9)16
 | (10)1 | 1 | (2)E3 |  | (2)E3 | 1 | (10)1
 | (10)2 | 2 | (2)E4 |  | (2)E4 | 2 | (10)2
 | (10)3 | 3 | (2)E5 |  | (2)E5 | 3 | (10)3
 | (10)4 | 4 | (2)E6 |  | (2)E6 | 4 | (10)4
 | (10)5 | 5 | (2)E7 |  | (2)E7 | 5 | (10)5
 | (10)6 | 6 | (2)E8 |  | (2)E8 | 6 | (10)6
 | (10)7 | 7 | (2)E9 |  | (2)E9 | 7 | (10)7
 | (10)8 | 8 | (2)E10 |  | (2)E10 | 8 | (10)8
 | (10)9 | 1 | (2)E11 |  | (2)E11 | 1 | (10)9
 | (10)10 | 2 | (2)E12 |  | (2)E12 | 2 | (10)10
 | (10)11 | 3 | (2)F1 |  | (2)F1 | 3 | (10)11
 | (10)12 | 4 | (2)F2 |  | (2)F2 | 4 | (10)12
 | (10)13 | 5 | (2)F3 |  | (2)F3 | 5 | (10)13
 | (10)14 | 6 | (2)F4 |  | (2)F4 | 6 | (10)14
 | (10)15 | 7 | (2)F5 |  | (2)F5 | 7 | (10)15
 | (10)16 | 8 | (2)F6 |  | (2)F6 | 8 | (10)16
 | (11)1 | 1 | (2)F7 |  | (2)F7 | 1 | (11)1
 | (11)2 | 2 | (2)F8 |  | (2)F8 | 2 | (11)2
 | (11)3 | 3 | (2)F9 |  | (2)F9 | 3 | (11)3
 | (11)4 | 4 | (2)F10 |  | (2)F10 | 4 | (11)4
 | (11)5 | 5 | (2)F11 |  | (2)F11 | 5 | (11)5
 | (11)6 | 6 | (2)F12 |  | (2)F12 | 6 | (11)6
 | (11)7 | 7 | (2)G1 |  | (2)G1 | 7 | (11)7
 | (11)8 | 8 | (2)G2 |  | (2)G2 | 8 | (11)8
 | (11)9 | 1 | (2)G3 |  | (2)G3 | 1 | (11)9
 | (11)10 | 2 | (2)G4 |  | (2)G4 | 2 | (11)10
 | (11)11 | 3 | (2)G5 |  | (2)G5 | 3 | (11)11
 | (11)12 | 4 | (2)G6 |  | (2)G6 | 4 | (11)12
 | (11)13 | 5 | (2)G7 |  | (2)G7 | 5 | (11)13
 | (11)14 | 6 | (2)G8 |  | (2)G8 | 6 | (11)14
 | (11)15 | 7 | (2)G9 |  | (2)G9 | 7 | (11)15
 | (11)16 | 8 | (2)G10 |  | (2)G10 | 8 | (11)16
 | (12)1 | 1 | (2)G11 |  | (2)G11 | 1 | (12)1
 | (12)2 | 2 | (2)G12 |  | (2)G12 | 2 | (12)2
 | (12)3 | 3 | (2)H1 |  | (2)H1 | 3 | (12)3
 | (12)4 | 4 | (2)H2 |  | (2)H2 | 4 | (12)4
 | (12)5 | 5 | (2)H3 |  | (2)H3 | 5 | (12)5
 | (12)6 | 6 | (2)H4 |  | (2)H4 | 6 | (12)6
 | (12)7 | 7 | (2)H5 |  | (2)H5 | 7 | (12)7
 | (12)8 | 8 | (2)H6 |  | (2)H6 | 8 | (12)8
 | (12)9 | 1 | (2)H7 |  | (2)H7 | 1 | (12)9
 | (12)10 | 2 | (2)H8 |  | (2)H8 | 2 | (12)10
 | (12)11 | 3 | (2)H9 |  | (2)H9 | 3 | (12)11
 | (12)12 | 4 | (2)H10 |  | (2)H10 | 4 | (12)12