I
L
T
A
W
H
I
T
E
P
A
P
E
R
|
L
I
T
I
G
A
T
I
O
N
A
N
D
P
R
A
C
T
I
C
E
S
U
P
P
O
R
T
29
To append the DateSent value to the next column for DocID A00000009,
first place the cursor in the first DocID row where the information is to be
appended (C2) and start typing =vlookup. Double-click on the symbol
when it appears:
The formula will appear, and you are ready to enter your values:
lookup_value
Common value for the document in both lists - in this case, the
DocID. To lock the value of the range and make it an absolute
value, the $ symbol has been added to the formula. This way
when the formula is copied down to other cells, the range will
not be modified.
table_array
Vector to look in. In this case the additional information is in
the sheet named Coding and the information is located in cells
A2 through E11.
col_index_num
The column number of the information to be added. In this
case, we want column C of the FileNames Sheet to hold the
DateSent or column B of the Coding Sheet, which is the 2nd
column:
To lock the value of the range and make it an absolute value,
the $ symbol has been added to the formula. When the formula
is copied down to other cells, this will prevent the range from
being adjusted.
[range_lookup]
This value can be either "True" or "False" which will look for
an exact match.
=VLOOKUP($A2, Coding!$A$2:$E$11,2,FALSE)