tying 2 Excel spreadsheets together

[Mary C]

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

 

[Gord Dibben]

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

 

[Mary C]

THanks I will do that!
--
Mary C

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