Lookup2.xlsx

	D	E	F	G	H
1
2	Salary Report
3	Name	Code	Basic Salary (RM)	Allowance (RM)	Total
4	Ahmad	AA
5	Hana	AB
6	Hanum	AD
7	Hidayah	AC
8	Azim	AA
9	Noraini	AD
10	Naraina	AC
11	Fatimah	AB
12	Aisyah	AC
13	Nurul	AD
14	Zetty	AE
15
16
17
18	Salary by Code
19	Code	Salary (RM)	Allowance
20	AA	8000	5%
21	AB	8500	6%
22	AC	9000	7%
23	AD	9500	8%
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