Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data, then adding data to the new spreadsheet.. a conund
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 & 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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data, then adding data to the new spreadsheet.. a conund
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 & 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;) One way is to use VLOOKUP. First put pairs of names and telephones in a list on a second sheet. Then, in the "added data" 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 "IF" function. An example is at http://www.contextures.com/xlFunctions02.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
Adding Data Information to a Chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |