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