ExcelBanter - Excel - linking cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel - linking cells (https://www.excelbanter.com/excel-worksheet-functions/34091-excel-linking-cells.html)

Cyndi

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!

Barb R.

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!

All times are GMT +1. The time now is 12:50 PM.