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!