ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
VLOOKUP: APPROXIMATE MATCH
2
What does it do?
Searches for a value in the first column of a table array
3
and returns a value in the same row from another column (to the right) in the table array.
4
Formula breakdown:
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
5
What it means:
VLOOKUP(this value, in this list, and get me value in this column, Approximate Match/TRUE])
6
7
Example:
8
9
10
11
col_index_1col_index_2
12
Income is Greater than or Equal to…Tax RateEnter Income
13
table_array$0 13%lookup_value
14
$8,456 18%Tax Rate
15
$15,874 22%
16
$36,897 30%
17
$87,458 39%
18
$141,569 45%
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