| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel workbook link
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel workbook link
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Excel Workbook to Powerpoint | Excel Worksheet Functions | |||
| How do i break a link to another excel workbook? | New Users to Excel | |||
| How to link a document to a workbook with a hyperlink in excel | Excel Worksheet Functions | |||
| link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
| how can i link sheets in my excel workbook | Excel Worksheet Functions | |||
Linear Mode
