Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking data?
I have one sheet with a list of ID numbers and there corresponding names. In
another sheed I have 100,000+ rows of data that contain the ID number as well as other data. Is there a way to add the names that correspond to the ID with out doing it one at a time? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking data?
On May 12, 5:07*pm, "Ron_Ron" <u51857@uwe wrote:
I have one sheet with a list of ID numbers and there corresponding names. *In another sheed I have 100,000+ rows of data that contain the ID number as well as other data. *Is there a way to add the names that correspond to the ID with out doing it one at a *time? Thanks. Look into the VLOOKUP function. Ken |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking data?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Data | Excel Worksheet Functions | |||
Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
Linking data | Excel Discussion (Misc queries) | |||
Linking Data | Excel Worksheet Functions |