Depending on the layout of your data, you may be able to use =vlookup() or
=index(match()).

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Excelhelp wrote:

I have two workbooks. They both have one thing in common, a person's SS#. I
want to link the two so that the worksheet in the second workbook will bring
up the person's name, address, ect... along with the SS#. What do I do?

Thanks!

--

Dave Peterson