TUGAS HLOOKUP VLOOKUP

		PT HARAPAN
	DAFTAR PENJUALAN TELEVISI
NO	KODE	JML	MERK	SOUND	LAYAR	UKURAN	HARGA	TERJUAL	TOTAL
1	AMC14	6	Akari	Mono	Cembung	14 Inci	Rp600.000	3	Rp3.600.000
2	JSF29	10	JVC	Stereo	Flat	29 Inci	Rp2.500.000	6	Rp25.000.000
3	JWF21	12	JVC	Sub woofer	Flat	21 Inci	Rp2.000.000	5	Rp24.000.000
4	LSP17	13	LG	Stereo	Plasma	17 Inci	Rp5.000.000	3	Rp65.000.000
5	LSL29	15	LG	Stereo	LCD	29 Inci	Rp4.000.000	10	Rp60.000.000
6	NWL40	20	Sony	Sub woofer	LCD	40 Inci	Rp6.000.000	4	Rp120.000.000
7	SSF40	8	Sharp	Stereo	Flat	40 Inci	Rp3.500.000	3	Rp28.000.000
8	SSF6O	10	Sharp	Stereo	Flat	60 Inci	Rp5.500.000	2	Rp55.000.000
9	TWP29	11	Toshiba	Sub woofer	Plasma	29 Inci	Rp10.000.000	1	Rp110.000.000
10	TWP21	15	Toshiba	Sub woofer	Plasma	21 Inci	Rp7.000.000	2	Rp105.000.000
REFERENSI:
UKURAN			MERK			LAYAR
14	14 Inci		A	Akari		C	F	L	P
17	17 Inci		J	JVC		Cembung	Flat	LCD	Plasma
21	21 Inci		L	LG
29	29 Inci		N	Sony
40	40 Inci		S	Sharp
60	60 Inci		T	Toshiba		SOUND
						M	S	W
						Mono	Stereo	Sub woofer