B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
Vlookup Function
9
10
11
0
E
12
60
D
13
70
C
14
80
B
15
90
A
16
17
18
19
20
21
22
23
24
25
26
Vlooklup searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
27
28
Change the value of Score and see how the letter grade changes.
29
30
31
32
This example is contributed by www.xlmacros.com
33
34
Copyright.
Anthony's VBA Page.
35
36
37
38
39
40
41
42
43
44
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.