|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
L
|
M
|
N
|
O
|
|
|
|
|
2
|
|
|
|
|
|
3
|
|
|
|
|
4
|
|
|
|
|
5
|
|
|
Show Formula:
|
|
|
|
6
|
|
|
|
7
|
|
|
8
|
|
|
Hlookup Function
|
|
|
|
9
|
|
|
|
10
|
|
|
|
A
|
B
|
C
|
D
|
E
|
|
11
|
|
|
|
378,476
|
490,836
|
121,957
|
43,213
|
28,060
|
|
12
|
|
|
487,073
|
600,000
|
235,432
|
844,324
|
195,349
|
|
13
|
|
|
500,000
|
856,434
|
454,334
|
968,593
|
548,588
|
|
14
|
|
|
529,146
|
948,494
|
571,227
|
998,858
|
583,598
|
|
15
|
|
|
600,000
|
989,859
|
660,300
|
958,969
|
822,342
|
|
16
|
|
|
|
|
|
17
|
|
|
|
|
|
|
|
18
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
20
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
22
|
|
|
|
|
|
|
23
|
|
|
|
|
|
24
|
|
|
|
|
|
25
|
|
|
26
|
|
|
Hlookup Looks in the top row of an array and returns
the value of the indicated cell.
|
|
27
|
|
|
|
|
|
28
|
|
|
Change the region at E17 and see the sales change.
|
|
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
|
|
|