Download Notes for Intro Guide

Transcript
6 Combining data from separate files
3. In the second row of this new column, insert the following function, replacing
each italicised argument with relevant values as described below. The function is:
=vlookup(value_to_match, datafile_dimensions, data_col)
where:
value_to_match is the cell reference of the unique case identifier in the open
spreadsheet (the one containing the verbatim)
datafile_dimensions gives a full reference to the second data file and the range of
cells within it that contain data
data_col is the number of the column in this second spreadsheet that contains the
data item that you wish to import.
A completed function might look like this:
=VLOOKUP(A2,’d:\wers98\sheet2.xls’!$A$2:$C$300,2)
In this case, data from column 2 of the second spreadsheet will be imported into
the cell containing the vlookup function, as long as a match can be found
between the unique case identifier in the verbatims file (held in cell A2) and a
value held in the first column of the second spreadsheet.
66