| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel - linking cells
How do I link a cell(s), (column of cells) in a worksheet to related
information in another worksheet or workbook? Example: Employee Number - when typed into a cell in a column named "EmpNo", I want Column B to automatically show the person's Employee Number as well as all other related information. I have Excel in Office 97 Thanks! |
|
#2
|
|||
|
|||
|
I'd use the VLOOKUP function. Use the EXCEL help feature to find out more
about it. "Cyndi" wrote: How do I link a cell(s), (column of cells) in a worksheet to related information in another worksheet or workbook? Example: Employee Number - when typed into a cell in a column named "EmpNo", I want Column B to automatically show the person's Employee Number as well as all other related information. I have Excel in Office 97 Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells in Excel? | Excel Discussion (Misc queries) | |||
| Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
| linking with cells of others excel file | Excel Discussion (Misc queries) | |||
| merging cells excel 2003 | Excel Discussion (Misc queries) | |||
| How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
Hybrid Mode
