contoh fungsi vlookup dan hlookup

LAPORAN BULANAN HOTEL

Tipe Kelas Tarif/hari TipeEKO Ekonomi Rp 500,000 KelasEXE Executive Rp 700,000 Tarif/hariVIP VIP Rp 1,000,000

No Nama Check in Check out Lama Tipe1 Hendro 12-Aug-10 17-Aug-10 5 EKO2 Abdul 2-Aug-10 16-Aug-10 14 VIP3 Denny 22-Aug-10 22-Aug-10 1 EXE4 Dewi 21-Aug-10 22-Aug-10 1 EXE5 Arif 10-Aug-10 12-Aug-10 2 VIP6 Terry 1-Aug-10 13-Aug-10 12 EKO7 Erina 27-Aug-10 31-Aug-10 4 EXE8 Wanady 12-Aug-10 15-Aug-10 3 VIP

LAPORAN BULANAN HOTEL

EKO EXE VIPEkonomi Executive VIP

Rp 500,000 Rp 700,000 Rp 1,000,000

Kelas Tarif/Hari Biaya Diskon PPH Jml BayarEkonomi Rp 500,000 Rp 2,500,000 Rp - Rp 250,000 Rp 2,750,000 VIP Rp 1,000,000 Rp 14,000,000 Rp 2,800,000 Rp 1,120,000 Rp 12,320,000 Executive Rp 700,000 Rp 700,000 Rp - Rp 70,000 Rp 770,000 Executive Rp 700,000 Rp 700,000 Rp - Rp 70,000 Rp 770,000 VIP Rp 1,000,000 Rp 2,000,000 Rp - Rp 200,000 Rp 2,200,000 Ekonomi Rp 500,000 Rp 6,000,000 Rp 1,200,000 Rp 480,000 Rp 5,280,000 Executive Rp 700,000 Rp 2,800,000 Rp - Rp 280,000 Rp 3,080,000 VIP Rp 1,000,000 Rp 3,000,000 Rp - Rp 300,000 Rp 3,300,000