Spreadsheet: 795968d1663037044-formula-to-look-left-and-offset-lookup_left_offset_example
Sheet: Example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESULTS SECTION
 |  |  |  |  |  | Section 2 |  |  | Section 3 |  |  | Section 4 |  |  | Section 5 |  |  | Section 6 |  |  | Section 7 |  |  | Section 8 |  |  | Section 9 |  |  | Section 10 |  |  | Section 11 |  |  | Section 12 |  |  | Section 13 |  |  | Section 14 |  |  | Section 15 |  |  | Section 16 |  |  | Section 17 |  |  | Section 18 |  |  | Section 19 |  |  | Section 20 |  |  | Section 21 |  |  | Section 22 |  |  | Section 23 |  |  | Section 24 |  |  | Section 25 |  |  | Section 26 |  |  | Section 27 |  |  | Section 28 |  |  | Section 29 |  |  | Section 30 |  |  | A (the first non-blank section looking left, beginning with section 30) |  |  | B (the second non-blank section looking left, beginning with section 30) |  |  | C (the third non-blank section looking left, beginning with section 30)
Job Code | Job Title | blank | Roll-Up Module Code 1 | Roll-Up Job Code 1 | Roll-Up Job Title 1 | Module 2 | Code 2 | Job 2 | Module 3 | Code 3 | Job 3 | Module 4 | Code 4 | Job 4 | Module 5 | Code 5 | Job 5 | Module 6 | Code 6 | Job 6 | Module 7 | Code 7 | Job 7 | Module 8 | Code 8 | Job 8 | Module 9 | Code 9 | Job 9 | Module 10 | Code 10 | Job 10 | Module 11 | Code 11 | Job 11 | Module 12 | Code 12 | Job 12 | Module 13 | Code 13 | Job 13 | Module 14 | Code 14 | Job 14 | Module 15 | Code 15 | Job 15 | Module 16 | Code 16 | Job 16 | Module 17 | Code 17 | Job 17 | Module 18 | Code 18 | Job 18 | Module 19 | Code 19 | Job 19 | Module 20 | Code 20 | Job 20 | Module 21 | Code 21 | Job 21 | Module 22 | Code 22 | Job 22 | Module 23 | Code 23 | Job 23 | Module 24 | Code 24 | Job 24 | Module 25 | Code 25 | Job 25 | Module 26 | Code 26 | Job 26 | Module 27 | Code 27 | Job 27 | Module 28 | Code 28 | Job 28 | Module 29 | Code 29 | Job 29 | Module 30 | Code 30 | Job 30 | Module A | Code A | Job A | Module B | Code B | Job B | Module C | Code C | Job C
EO.GLAD.E2 | General - Head of Asset Management - Corporate - Executive 2 (E2) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EB | All Areas Roll-Up - All Focuses Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0F5.EB | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 1 & 2 (EB) | EXM | 00.0000.E2 | All Areas Roll-Up - All Focuses Roll-Up - Executive 2 (E2) | EXM | F0.A0F5.E2 | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 2 (E2) | EXM | EO.0000.EX | All Areas Roll-Up - All Focuses Roll-UpExecutive 1,2,3,4,5 (EX) | EXM | EO.GL00.EX | General - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | EO.0000.EB | All Areas Roll-Up - All Focuses Roll-UpExecutive 1 & 2 (EB) | EXM | F0.A0X6.EB | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 1 & 2 (EB) | EXM | EO.GL00.EB | General - All Focuses Roll-Up - Executive 1 & 2 (EB) | EXM | EO.0000.E2 | All Areas Roll-Up - All Focuses Roll-UpExecutive 2 (E2) | EXM | F0.A0X1.EB | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X7.EB | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X6.E2 | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 2 (E2) | EXM | F0.A0X9.EB | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 1 & 2 (EB) | EXM | EO.GL00.E2 | General - All Focuses Roll-Up - Executive 2 (E2) | EXM | F0.A0Y1.EB | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X1.E2 | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 2 (E2) | EXM | F0.A0X4.EB | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X5.EB | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X8.EB | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X7.E2 | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 2 (E2) | EXM | F0.A0X9.E2 | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 2 (E2) | EXM | F0.A0Y2.EB | Cross-Area Roll-Up - Energy Hydropower Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0Y1.E2 | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 2 (E2) | EXM | F0.A0X4.E2 | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 2 (E2) | EXM | F0.A0X5.E2 | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 2 (E2) | EXM | F0.A0X8.E2 | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 2 (E2) | EXM | F0.A0Y2.E2 | Cross-Area Roll-Up - Energy Hydropower Roll-Up - Executive 2 (E2) | EXM | EO.GLAD.EB | General - Head of Asset Management - Corporate - Executive 1 & 2 (EB)
EO.GLAD.E3 | General - Head of Asset Management - Corporate - Executive 3 (E3) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EA | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0F5.EA | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 & 4 (EA) | EXM | 00.0000.E3 | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 (E3) | EXM | F0.A0F5.E3 | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 (E3) | EXM | EO.0000.EX | All Areas Roll-Up - All Focuses Roll-UpExecutive 1,2,3,4,5 (EX) | EXM | EO.GL00.EX | General - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | EO.0000.EA | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 & 4 (EA) | EXM | F0.A0X6.EA | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 3 & 4 (EA) | EXM | EO.GL00.EA | General - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.EA | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 3 & 4 (EA) | EXM | EO.0000.E3 | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 (E3) | EXM | F0.A0X9.EA | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X7.EA | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 3 & 4 (EA)
EO.GLAD.E4 | General - Head of Asset Management - Corporate - Executive 4 (E4) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EA | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0F5.EA | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 & 4 (EA) | EXM | 00.0000.E4 | All Areas Roll-Up - All Focuses Roll-Up - Executive 4 (E4) | EXM | F0.A0F5.E4 | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 4 (E4) | EXM | EO.0000.EX | All Areas Roll-Up - All Focuses Roll-UpExecutive 1,2,3,4,5 (EX) | EXM | EO.GL00.EX | General - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | EO.0000.EA | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 & 4 (EA) | EXM | F0.A0X6.EA | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 3 & 4 (EA) | EXM | EO.GL00.EA | General - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.EA | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 3 & 4 (EA) | EXM | EO.0000.E4 | All Areas Roll-Up - All Focuses Roll-UpExecutive 4 (E4) | EXM | F0.A0X9.EA | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X7.EA | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X6.E4 | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 4 (E4) | EXM | EO.GL00.E4 | General - All Focuses Roll-Up - Executive 4 (E4) | EXM | F0.A0Y1.EA | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.E4 | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 4 (E4) | EXM | F0.A0X4.EA | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X5.EA | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X8.EA | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X9.E4 | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 4 (E4)
EO.GLCD.E2 | General - Head of Control Operations - Corporate - Executive 2 (E2) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EB | All Areas Roll-Up - All Focuses Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0F5.EB | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 1 & 2 (EB) | EXM | 00.0000.E2 | All Areas Roll-Up - All Focuses Roll-Up - Executive 2 (E2) | EXM | F0.A0F5.E2 | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 2 (E2) | EXM | EO.0000.EX | All Areas Roll-Up - All Focuses Roll-UpExecutive 1,2,3,4,5 (EX) | EXM | EO.GL00.EX | General - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | EO.0000.EB | All Areas Roll-Up - All Focuses Roll-UpExecutive 1 & 2 (EB) | EXM | F0.A0X6.EB | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 1 & 2 (EB) | EXM | EO.GL00.EB | General - All Focuses Roll-Up - Executive 1 & 2 (EB) | EXM | EO.0000.E2 | All Areas Roll-Up - All Focuses Roll-UpExecutive 2 (E2) | EXM | F0.A0X1.EB | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X7.EB | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X6.E2 | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 2 (E2) | EXM | F0.A0X9.EB | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 1 & 2 (EB) | EXM | EO.GL00.E2 | General - All Focuses Roll-Up - Executive 2 (E2) | EXM | F0.A0Y1.EB | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X1.E2 | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 2 (E2) | EXM | F0.A0X4.EB | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X5.EB | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X8.EB | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0X7.E2 | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 2 (E2) | EXM | F0.A0X9.E2 | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 2 (E2) | EXM | F0.A0Y2.EB | Cross-Area Roll-Up - Energy Hydropower Roll-Up - Executive 1 & 2 (EB)
EO.GLCD.E3 | General - Head of Control Operations - Corporate - Executive 3 (E3) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EA | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0F5.EA | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 & 4 (EA) | EXM | 00.0000.E3 | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 (E3) | EXM | F0.A0F5.E3 | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 (E3) | EXM | EO.0000.EX | All Areas Roll-Up - All Focuses Roll-UpExecutive 1,2,3,4,5 (EX) | EXM | EO.GL00.EX | General - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | EO.0000.EA | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 & 4 (EA) | EXM | F0.A0X6.EA | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 3 & 4 (EA) | EXM | EO.GL00.EA | General - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.EA | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 3 & 4 (EA) | EXM | EO.0000.E3 | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 (E3) | EXM | F0.A0X9.EA | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X7.EA | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X6.E3 | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 3 (E3) | EXM | EO.GL00.E3 | General - All Focuses Roll-Up - Executive 3 (E3) | EXM | F0.A0Y1.EA | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.E3 | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 3 (E3) | EXM | F0.A0X4.EA | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X5.EA | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X8.EA | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X9.E3 | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 3 (E3) | EXM | F0.A0X7.E3 | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 3 (E3) | EXM | F0.A0Y1.E3 | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 3 (E3) | EXM | F0.A0Y2.EA | Cross-Area Roll-Up - Energy Hydropower Roll-Up - Executive 3 & 4 (EA)
EO.GLLD.E3 | General - Head of Land Permits / Negotiations - Corporate - Executive 3 (E3) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EA | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0F5.EA | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 & 4 (EA) | EXM | 00.0000.E3 | All Areas Roll-Up - All Focuses Roll-Up - Executive 3 (E3) | EXM | F0.A0F5.E3 | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 3 (E3) | EXM | EO.0000.EX | All Areas Roll-Up - All Focuses Roll-UpExecutive 1,2,3,4,5 (EX) | EXM | EO.GL00.EX | General - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | EO.0000.EA | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 & 4 (EA) | EXM | F0.A0X6.EA | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 3 & 4 (EA) | EXM | EO.GL00.EA | General - All Focuses Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.EA | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 3 & 4 (EA) | EXM | EO.0000.E3 | All Areas Roll-Up - All Focuses Roll-UpExecutive 3 (E3) | EXM | F0.A0X9.EA | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X7.EA | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X6.E3 | Cross-Area Roll-Up - Energy Renewables & Power Roll-Up - Executive 3 (E3) | EXM | EO.GL00.E3 | General - All Focuses Roll-Up - Executive 3 (E3) | EXM | F0.A0Y1.EA | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X1.E3 | Cross-Area Roll-Up - Energy Oil & Gas Roll-Up - Executive 3 (E3) | EXM | F0.A0X4.EA | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X5.EA | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X8.EA | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X9.E3 | Cross-Area Roll-Up - Energy Oil & Gas - Upstream Roll-Up - Executive 3 (E3) | EXM | F0.A0X7.E3 | Cross-Area Roll-Up - Energy Renewables Roll-Up - Executive 3 (E3) | EXM | F0.A0Y1.E3 | Cross-Area Roll-Up - Energy - Mining, Infrastructure & Engineering Roll-Up - Executive 3 (E3) | EXM | F0.A0Y2.EA | Cross-Area Roll-Up - Energy Hydropower Roll-Up - Executive 3 & 4 (EA) | EXM | F0.A0X4.E3 | Cross-Area Roll-Up - Energy Oil & Gas - Midstream Roll-Up - Executive 3 (E3) | EXM | F0.A0X5.E3 | Cross-Area Roll-Up - Energy Oil & Gas - Downstream Roll-Up - Executive 3 (E3) | EXM | F0.A0X8.E3 | Cross-Area Roll-Up - Energy Nuclear Roll-Up - Executive 3 (E3) | EXM | F0.A0Y2.E3 | Cross-Area Roll-Up - Energy Hydropower Roll-Up - Executive 3 (E3)
EO.GLAD.E2 | General - Head of Asset Management - Corporate - Executive 2 (E2) |  | EXM | 00.0000.EX | All Areas Roll-Up - All Focuses Roll-Up - Executive 1,2,3,4,5 (EX) | EXM | 00.0000.EB | All Areas Roll-Up - All Focuses Roll-Up - Executive 1 & 2 (EB) | EXM | F0.A0F5.EB | Cross-Area Roll-Up - All Executives Except Sales Roll-Up - Executive 1 & 2 (EB) | EXM | 00.0000.E2 | All Areas Roll-Up - All Focuses Roll-Up - Executive 2 (E2)