software

I have imported data from one Excel spreadsheet into a new spreadsheet e.g. a
list of names. Now I wish to add data (which isn't imported) e.g. telephone
numbers in the same rows as the imported data. This data (telephone numbers)
relates to the imported data (names). However, if I were to delete a row in
the original spreasheet listing the names, and then refreshed the new
spreadsheet, the names and telephones wouldn't match up anymore. How do I
ensure that the names amp; telephone numbers do match up after the source of the
imported data is changed? (this is only an example.. I'm not really matching
names and telephone numbers in this way

--
Andreas L.

gt; I have imported data from one Excel spreadsheet into a new spreadsheet
gt; e.g. a list of names. Now I wish to add data (which isn't imported)
gt; e.g. telephone numbers in the same rows as the imported data. This
gt; data (telephone numbers) relates to the imported data (names).
gt; However, if I were to delete a row in the original spreasheet listing
gt; the names, and then refreshed the new spreadsheet, the names and
gt; telephones wouldn't match up anymore. How do I ensure that the names amp;
gt; telephone numbers do match up after the source of the imported data is
gt; changed? (this is only an example.. I'm not really matching names and
gt; telephone numbers in this way

One way is to use VLOOKUP.

First put pairs of names and telephones in a list on a second sheet.

Then, in the quot;added dataquot; column, use the VLOOKUP function, referring to
the second sheet. To deal with the situation where a value is missing from
the second sheet, wrap the VLOOKUP inside an quot;IFquot; function. An example is
at
www.contextures.com/xlFunctions02.html