006. Vlookup Hlookup dan Lookup Excel.xlsx

	B	C	D	E	F	G	H	I	J
1
2	NO.	NIS	NAMA SISWA	NILAI					TOTAL NILAI
3	NO.	NIS	NAMA SISWA	PAI	B. INDO	IPA	IPS	MTK	TOTAL NILAI
4	1	22230001	ALI	77	72	78	89	85	401
5	2	22230002	BUDI	84	72	71	72	69	368
6	3	22230003	CECEP	73	75	78	75	80	381
7	4	22230004	DINA	69	90	73	74	74	380
8	5	22230005	ENDAH	75	74	88	77	83	397
9	6	22230006	FANDI	73	86	88	89	76	412
10	7	22230007	GANI	77	69	72	73	74	365
11	8	22230008	HANNY	80	87	87	81	69	404
12	9	22230009	INDAH	90	78	77	82	79	406
13	10	22230010	JENIFER	69	89	80	81	80	399
14	11	22230011	KARIM	82	72	79	81	88	402
15	12	22230012	LULU	74	76	73	82	76	381
16
17	NO.	NIS	NAMA SISWA	TOTAL NILAI
18	1	22230001	ALI	401
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100