Spreadsheet: 269343d1381136373-stuck-in-doing-a-complex-look-up-command-to-populate-a-list-cable-data
Sheet: Data

 | Cable Information |  |  |  |  |  |  |  |  |  |  |  |  | Gland Information
 | BS Ref. | No. of Cores | Nom. Cross Sectional Area of Conductor mm² | Overall Cable Ø | Thickness of Oversheath | [NAME] | [NAME] | [NAME] | Under [NAME] |  |  |  |  | Under [NAME] | Overall Ø | [NAME] | Gland Size | Gland No. |  |  |  |  |  |  |  |  |  | BS Ref | Cores | Cable Ø | Under [NAME] | [NAME]
 | 5467 | 2 | 1.5A | 12.1 | 1.3 | Steel | 0.9 |  |  |  |  |  |  | 11.6 | 15.8 | 0.9 | 20S | 410BW-52 |  |  |  |  |  |  |  |  |  | 5476 | 2 | 12.1
 | 5467 | 2 | 2.5 | 13.6 | 1.4 | Steel | 0.9 |  |  |  |  |  |  | 11.6 | 15.8 | 0.9 | 20S | 410BE-52 |  |  |  |  |  |  |  |  |  | 6724 | 3 | 12.6
 | 5467 | 2 | 4 | 14.7 | 1.4 | Steel | 0.9 |  |  |  |  |  |  | 11.6 | 15.8 | 0.9 | 20S | 417AA-52 |  |  |  |  |  |  |  |  |  |  | 4 | 13.3
 | 5467 | 2 | 6 | 15.9 | 1.4 | Steel | 0.9 |  |  |  |  |  |  | 11.6 | 15.8 | 0.9 | 20SR | 417AA-22 |  |  |  |  |  |  |  |  |  |  | 5 | 13.6
 | 5467 | 2 | 10 | 18 | 1.5 | Steel | 0.9 |  |  |  |  |  |  | 11.6 | 15.8 | 1.25 | 20S | 410BE-52 |  |  |  |  |  |  |  |  |  |  |  | 14.1
 | 5467 | 2 | 16 | 20.4 | 1.5 | Steel | 1.25 |  |  |  |  |  |  | 13.9 | 20.8 | 0.9 | 20 | 410BW-53 |  |  |  |  |  |  |  |  |  |  |  | 14.3
 | 5467 | 2 | 25 | 24.1 | 1.6 | Steel | 1.25 |  |  |  |  |  |  | 13.9 | 20.8 | 0.9 | 20 | 410BE-53 |  |  |  |  |  |  |  |  |  |  |  | 14.7
 | 5467 | 2 | 25 | 20.4 | 1.6 | Steel | 1.25 |  |  |  |  |  |  | 13.9 | 20.8 | 0.9 | 20 | 417AA-53 |  |  |  |  |  |  |  |  |  |  |  | 15
 | 5467 | 2 | 35 | 27.7 | 1.7 | Steel | 1.6 |  |  |  |  |  |  | 13.9 | 20.8 | 1.25 | 20 | 410BW-53 |  |  |  |  |  |  |  |  |  |  |  | 15.3
 | 5467 | 2 | 35 | 23.3 | 1.7 | Steel | 1.6 |  |  |  |  |  |  | 13.9 | 20.8 | 1.25 | 20 | 410BE-53 |  |  |  |  |  |  |  |  |  |  |  | 15.9
 | 5467 | 2 | 50 | 30.8 | 1.9 | Steel | 1.6 |  |  |  |  |  |  | 13.9 | 20.8 | 1.25 | 20 | 417AA-53 |  |  |  |  |  |  |  |  |  |  |  | 16.1
 | 5467 | 2 | 50 | 25.8 | 1.8 | Steel | 1.6 |  |  |  |  |  |  | 19.9 | 27.2 | 1.25 | 25 | 410BW-55 |  |  |  |  |  |  |  |  |  |  |  | 16.4
 | 5467 | 2 | 70 | 36.2 | 2 | Steel | 2 |  |  |  |  |  |  | 19.9 | 27.2 | 1.25 | 25 | 410BE-55 |  |  |  |  |  |  |  |  |  |  |  | 16.6
 | 5467 | 2 | 70 | 29 | 1.9 | Steel | 1.6 |  |  |  |  |  |  | 19.9 | 27.2 | 1.25 | 25 | 417AA-55 |  |  |  |  |  |  |  |  |  |  |  | 17.8
 | 5467 | 2 | 95 | 40.2 | 2.1 | Steel | 2 |  |  |  |  |  |  | 19.9 | 27.2 | 1.25 | 25 | 417AA-55 |  |  |  |  |  |  |  |  |  |  |  | 18
 | 5467 | 2 | 95 | 33.1 | 2 | Steel | 2 |  |  |  |  |  |  | 19.9 | 27.2 | 1.6 | 25 | 410BW-55 |  |  |  |  |  |  |  |  |  |  |  | 18.7
 | 5467 | 2 | 120 | 44.1 | 2.1 | Steel | 2 |  |  |  |  |  |  | 19.9 | 27.2 | 1.6 | 25 | 410BE-55 |  |  |  |  |  |  |  |  |  |  |  | 19.5
 | 5467 | 2 | 120 | 36.1 | 2.1 | Steel | 2 |  |  |  |  |  |  | 26.2 | 33.5 | 1.6 | 32 | 410BW-56 |  |  |  |  |  |  |  |  |  |  |  | 20
 | 5467 | 2 | 150 | 39.3 | 2.2 | Steel | 2 |  |  |  |  |  |  | 26.2 | 33.5 | 1.6 | 32 | 410BE-56 |  |  |  |  |  |  |  |  |  |  |  | 20.4
 | 5467 | 2 | 185 | 44.7 | 2.4 | Steel | 2.5 |  |  |  |  |  |  | 26.2 | 33.5 | 1.6 | 32 | 417AA-56 |  |  |  |  |  |  |  |  |  |  |  | 20.4
 | 5467 | 2 | 240 | 49 | 2.5 | Steel | 2.5 |  |  |  |  |  |  | 26.2 | 33.5 | 1.6 | 32 | 417AA-56 |  |  |  |  |  |  |  |  |  |  |  | 21.1
 | 5467 | 2 | 300 | 53.5 | 2.6 | Steel | 2.5 |  |  |  |  |  |  | 26.2 | 33.5 | 2 | 32 | 410BW-56 |  |  |  |  |  |  |  |  |  |  |  | 21.6
 | 5467 | 2 | 400 | 59 | 2.8 | Steel | 2.5 |  |  |  |  |  |  | 26.2 | 33.5 | 2 | 32 | 410BE-56 |  |  |  |  |  |  |  |  |  |  |  | 22.9
 | 5467 | 3 | 1.5 | 12.6 | 1.3 | Steel | 0.9 |  |  |  |  |  |  | 32.1 | 39.9 | 1.6 | 40 | 410BW-57 |  |  |  |  |  |  |  |  |  |  |  | 23.3
 | 5467 | 3 | 2.5 | 14.1 | 1.4 | Steel | 0.9 |  |  |  |  |  |  | 32.1 | 39.9 | 1.6 | 40 | 410BE-57 |  |  |  |  |  |  |  |  |  |  |  | 23.4
 | 5467 | 3 | 4 | 15.3 | 1.4 | Steel | 0.9 |  |  |  |  |  |  | 32.1 | 39.9 | 1.6 | 40 | 417AA-57 |  |  |  |  |  |  |  |  |  |  |  | 23.6
 | 5467 | 3 | 6 | 16.6 | 1.4 | Steel | 0.9 |  |  |  |  |  |  | 32.1 | 39.9 | 2 | 40 | 410BW-57 |  |  |  |  |  |  |  |  |  |  |  | 24.1
 | 5467 | 3 | 10 | 19.5 | 1.5 | Steel | 1.25 |  |  |  |  |  |  | 32.1 | 39.9 | 2 | 40 | 410BE-57 |  |  |  |  |  |  |  |  |  |  |  | 25.7
 | 5467 | 3 | 16 | 21.6 | 1.6 | Steel | 1.25 |  |  |  |  |  |  | 32.1 | 39.9 | 2 | 40 | 417AA-57 |  |  |  |  |  |  |  |  |  |  |  | 25.8
 | 5467 | 3 | 25 | 26.7 | 1.7 | Steel | 1.6 |  |  |  |  |  |  | 38.1 | 46.3 | 2 | 50S | 417AA-58 |  |  |  |  |  |  |  |  |  |  |  | 26.1
 | 5467 | 3 | 25 | 23.6 | 1.7 | Steel | 1.6 |  |  |  |  |  |  | 38.1 | 46.3 | 2.5 | 50S | 417AA-58 |  |  |  |  |  |  |  |  |  |  |  | 26.6
 | 5467 | 3 | 35 | 29.4 | 1.8 | Steel | 1.6 |  |  |  |  |  |  | 44 | 52.6 | 2 | 50 | 410BE-59 |  |  |  |  |  |  |  |  |  |  |  | 26.7
 | 5467 | 3 | 35 | 25.7 | 1.8 | Steel | 1.6 |  |  |  |  |  |  | 44 | 52.6 | 2 | 50 | 417AA-59 |  |  |  |  |  |  |  |  |  |  |  | 27.7
 | 5467 | 3 | 50 | 32.5 | 1.9 | Steel | 1.6 |  |  |  |  |  |  | 44 | 52.6 | 2.5 | 50 | 410BW-59 |  |  |  |  |  |  |  |  |  |  |  | 28.5
 | 5467 | 3 | 50 | 28.5 | 1.8 | Steel | 1.6 |  |  |  |  |  |  | 44 | 52.6 | 2.5 | 50 | 410BW-59 |  |  |  |  |  |  |  |  |  |  |  | 28.6
 | 5467 | 3 | 70 | 38.3 | 2 | Steel | 2 |  |  |  |  |  |  | 44 | 52.6 | 2.5 | 50 | 410BE-59 |  |  |  |  |  |  |  |  |  |  |  | 28.9
 | 5467 | 3 | 70 | 32.2 | 1.9 | Steel | 1.6 |  |  |  |  |  |  | 44 | 52.6 | 2.5 | 50 | 417AA-59 |  |  |  |  |  |  |  |  |  |  |  | 29
 | 5467 | 3 | 95 | 42.6 | 2.2 | Steel | 2 |  |  |  |  |  |  | 50 | 58.9 | 2.5 | 63S | 417AA-60 |  |  |  |  |  |  |  |  |  |  |  | 29.4
 | 5467 | 3 | 95 | 37 | 2.1 | Steel | 2 |  |  |  |  |  |  | 55.9 | 65.3 | 2.5 | 63 | 410BW-61 |  |  |  |  |  |  |  |  |  |  |  | 30.8
 | 5467 | 3 | 120 | 48.1 | 2.3 | Steel | 2.5 |  |  |  |  |  |  | 55.9 | 65.3 | 2.5 | 63 | 410BE-61 |  |  |  |  |  |  |  |  |  |  |  | 31.5
 | 5467 | 3 | 120 | 40.4 | 2.2 | Steel | 2 |  |  |  |  |  |  | 55.9 | 65.3 | 2.5 | 63 | 417AA-61 |  |  |  |  |  |  |  |  |  |  |  | 31.9
 | 5467 | 3 | 150 | 45.5 | 2.3 | Steel | 2.5 |  |  |  |  |  |  | 61.9 | 71.6 | 2.5 | 75S | 410BW-62 |  |  |  |  |  |  |  |  |  |  |  | 32
 | 5467 | 3 | 185 | 49.8 | 2.4 | Steel | 2.5 |  |  |  |  |  |  | 61.9 | 71.6 | 2.5 | 75S | 417AA-62 |  |  |  |  |  |  |  |  |  |  |  | 32.2
 | 5467 | 3 | 240 | 55.1 | 2.6 | Steel | 2.5 |  |  |  |  |  |  | 67.9 | 78 | 2.5 | 75 | 410BW-63 |  |  |  |  |  |  |  |  |  |  |  | 32.5
 | 5467 | 3 | 300 | 60.2 | 2.7 | Steel | 2.5 |  |  |  |  |  |  | 67.9 | 78 | 2.5 | 75 | 410BE-63 |  |  |  |  |  |  |  |  |  |  |  | 33.1
 | 5467 | 3 | 400 | 66.6 | 2.9 | Steel | 2.5 |  |  |  |  |  |  | 67.9 | 78 | 2.5 | 75 | 417AA-63 |  |  |  |  |  |  |  |  |  |  |  | 34.8
 | 5487 | 4 | 1.5 | 13.3 | 1.3 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.1
 | 5487 | 4 | 2.5 | 15 | 1.4 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.2 |  | 0.9
 | 5487 | 4 | 4 | 16.4 | 1.4 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.6 |  | 1.25
 | 5487 | 4 | 6 | 18.7 | 1.5 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  | 1.6
 | 5487 | 4 | 10 | 21.1 | 1.5 | Steel | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37.7 |  | 2
 | 5487 | 4 | 16 | 23.4 | 1.6 | Steel | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38.3 |  | 2.5
 | 5487 | 4 | 25 | 28.9 | 1.7 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39.3 |  | 3.15
 | 5487 | 4 | 25 | 26.1 | 1.7 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.2
 | 5487 | 4 | 35 | 31.9 | 1.8 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.4
 | 5487 | 4 | 35 | 28.6 | 1.8 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.4
 | 5487 | 4 | 50 | 36.6 | 2 | Steel | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41.7
 | 5487 | 4 | 50 | 32 | 1.9 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41.9
 | 5487 | 4 | 70 | 41.9 | 2.2 | Steel | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.6
 | 5487 | 4 | 70 | 37.7 | 2.1 | Steel | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.1
 | 5487 | 4 | 95 | 48.1 | 2.3 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44.7
 | 5487 | 4 | 95 | 41.7 | 2.2 | Steel | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45.5
 | 5487 | 4 | 120 | 52.6 | 2.4 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46.3
 | 5487 | 4 | 120 | 47.1 | 2.3 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47.1
 | 5487 | 4 | 150 | 51.4 | 2.4 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48.1
 | 5487 | 4 | 185 | 56.6 | 2.6 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48.1
 | 5487 | 4 | 240 | 63 | 2.7 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 | 5487 | 4 | 300 | 68.8 | 2.9 | Steel | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49.8
 | 5487 | 4 | 400 | 78.1 | 3.2 | Steel | 3.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51.4
 | 5487 | 5 | 1.5 | 14.3 | 1.4 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52.6
 | 5487 | 5 | 2.5 | 16.1 | 1.4 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53.5
 | 5487 | 5 | 4 | 17.8 | 1.5 | Steel | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.1
 | 5487 | 5 | 6 | 20 | 1.5 | Steel | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56.6
 | 5487 | 5 | 10 | 22.9 | 1.6 | Steel | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
 | 5487 | 5 | 16 | 26.6 | 1.7 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60.2
 | 5487 | 5 | 25 | 31.5 | 1.8 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 | 5487 | 5 | 35 | 34.8 | 1.9 | Steel | 1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66.6
 | 5487 | 5 | 50 | 40.4 | 2 | Steel | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68.8
 | 5487 | 5 | 70 | 46.3 | 2.2 | Steel | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78.1