This document contains lists of names, equipment, and discipline/subcontractor data. It uses INDEX and MATCH functions to look up values from these lists.
This document contains lists of names, equipment, and discipline/subcontractor data. It uses INDEX and MATCH functions to look up values from these lists.
This document contains lists of names, equipment, and discipline/subcontractor data. It uses INDEX and MATCH functions to look up values from these lists.
This document contains lists of names, equipment, and discipline/subcontractor data. It uses INDEX and MATCH functions to look up values from these lists.
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 4
List Nama Bob Rusydan Jasmine Iis
baris atau kolom 2
Rusydan =INDEX(C3:F3,C9) List Equipment Tank Farm Refinery Power House Pump House Fractination Diesel Storage CPO Loading Cooling Tower Utility Area CPO Unloading Hotwell Packaging Area
baris 2 kolom 3 Diesel Storage =INDEX(C3:E6,C8,C9) List Nama Bob Rusydan Jasmine Iis
baris atau kolom 3
Jasmine =INDEX(C3:C6,C9) Data Discipline & Subcont code discipline subcont CVL Civil Work PT. DDT STR Structure Work PT. KGM MS Mechanical Static PT. DKP MR Mechanical Rotating PT. DKP PW Piping Work PT. PPS EW Electrical Work TBE IW Instrument Work TBE
code IW 1 mencari discipline Instrument Work =INDEX(C4:E10,MATCH(C13,C4:C10,0),2)
subcont PT. PPS
2 mencari discipline Piping Work =INDEX(C4:E10,MATCH(C17,E4:E10,0),2)
