Vlookup.xlsx

	A	B	C	D	E	F	G	H
1	BurkeyAcademy
2	Vlookup BootCamp
3	Letter	Grade Average	LNAME	FNAME	Major	ZIP	Town	MHI
4	B	87.954	Smith	Joe	FIN	27313	PLEASANT GARDEN	$ 49,569.00
5	A	93.370	Doe	Jane	ECON	27047	SILOAM	$ 36,719.00
6	F	53.281	Brown	Hugh	MKT	28137	RICHFIELD	$ 35,313.00
7	F	57.549	Black	Alice	ECON	27546	LILLINGTON	$ 36,290.00
8	C	71.801	Cole	Mike	MKT	28766	PENROSE	$ 42,642.00
9	D	67.035	Greene	James	MKT	28128	NORWOOD	$ 37,026.00
10	B	83.107	Blue	Henry	FIN	28071	GOLD HILL	$ 39,926.00
11	F	52.201	Mustard	Colonel	FIN	27248	FRANKLINVILLE	$ 34,750.00
12	C	79.390	Rouge	Tara	MKT	28616	CROSSNORE	$ 27,500.00
13
14		=vlookup(what,where, column #, 0 or 1)
15
16			0	F
17			60	D
18			70	C
19			80	B
20			90	A
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