vlook

2
KODE NAMA MATERIAL HARGA SATUAN 1 UKNK Kenek 65,000 2 UTGI Tenaga Ahli ### 3 UMNR Mandor ### 1 MSTR Semen tiga roda 70,000 2 MPKU Paku 10,000 3 M 01.03 Genteng Metal 85,000 4 M 01.04 Besi 16mm 90,000 5 M 01.05 Besi 19mm ### 6 M 01.06 Keramik Roman 60x60 75,000 7 M 01.07 Hebel 80,000

Upload: dwi-haryanto

Post on 30-Sep-2015

218 views

Category:

Documents


2 download

DESCRIPTION

contoh Vlook Excel

TRANSCRIPT

Sheet1KODENAMA MATERIALHARGA SATUAN1UKNKKenek65,0002UTGITenaga Ahli100,0003UMNRMandor150,0001MSTRSemen tiga roda70,0002MPKUPaku10,0003M 01.03Genteng Metal85,0004M 01.04Besi 16mm90,0005M 01.05Besi 19mm130,0006M 01.06Keramik Roman 60x6075,0007M 01.07Hebel80,000

Sheet2NoUraianKodeQtySatHarga SatJumlahUpah1KenekUKNK265,000.00650002KenekUKNK265,000.00650003MandorUMNR1150,000.00150000Material1Semen tiga rodaM 01.0210ERROR:#N/AERROR:#N/A2HebelM 01.0310085,000.00850003Genteng MetalM 01.075080,000.0080000

Sheet3