Data Hlookup

<

Golongan	1	2	3	4	5
Gaji	Rp2,000,000.00	Rp2,500,000.00	Rp3,000,000.00	Rp4,500,000.00	Rp7,000,000.00
Tunjangan	Rp1,200,000.00	Rp1,500,000.00	Rp1,800,000.00	Rp2,700,000.00	Rp4,200,000.00
No	Nama Pegawai	Golongan	Gaji	Tunjangan	Jumlah
1	Anoman	5	Rp7,000,000.00	Rp4,200,000.00	Rp11,200,000.00
2	Banowati	3	Rp3,000,000.00	Rp1,800,000.00	Rp4,800,000.00
3	Citraksi	4	Rp4,500,000.00	Rp2,700,000.00	Rp7,200,000.00
4	Dursosono	2	Rp2,500,000.00	Rp1,500,000.00	Rp4,000,000.00
5	Endang Sumini	5	Rp7,000,000.00	Rp4,200,000.00	Rp11,200,000.00
6	Fataria	2	Rp2,500,000.00	Rp1,500,000.00	Rp4,000,000.00
7	Gatotkoco	3	Rp3,000,000.00	Rp1,800,000.00	Rp4,800,000.00
8	Hario Suman	4	Rp4,500,000.00	Rp2,700,000.00	Rp7,200,000.00
9	Jagalabilowo	5	Rp7,000,000.00	Rp4,200,000.00	Rp11,200,000.00
10	Kartomarmo	4	Rp4,500,000.00	Rp2,700,000.00	Rp7,200,000.00