Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tying 2 Excel spreadsheets together
I have 2 excel spreadsheets, one is a master agent list with agent number,
address, city, state zip. Second one is a spreadsheet with agent number and other information on it. I need to pull the addresses from the first spreadsheet to the second spreadsheet. the common denominator is the agent number. Can this be done?-- Mary C |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
tying 2 Excel spreadsheets together
VLOOKUP function could be what you need.
You need a lookup range of at least two columns and a cell for "what" to lookup. Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting Agent ID number.. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Wed, 23 Jul 2008 14:46:02 -0700, Mary C (donotspam) wrote: I have 2 excel spreadsheets, one is a master agent list with agent number, address, city, state zip. Second one is a spreadsheet with agent number and other information on it. I need to pull the addresses from the first spreadsheet to the second spreadsheet. the common denominator is the agent number. Can this be done?-- Mary C |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
tying 2 Excel spreadsheets together
THanks I will do that!
-- Mary C "Gord Dibben" wrote: VLOOKUP function could be what you need. You need a lookup range of at least two columns and a cell for "what" to lookup. Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting Agent ID number.. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Wed, 23 Jul 2008 14:46:02 -0700, Mary C (donotspam) wrote: I have 2 excel spreadsheets, one is a master agent list with agent number, address, city, state zip. Second one is a spreadsheet with agent number and other information on it. I need to pull the addresses from the first spreadsheet to the second spreadsheet. the common denominator is the agent number. Can this be done?-- Mary C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tying columns of data into a specified page size | Excel Worksheet Functions | |||
tying columns of data into a specified page size | New Users to Excel | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
Tying an imported graphic to a cell | Excel Discussion (Misc queries) |