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