Excel - linking cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
I'd use the VLOOKUP function. Use the EXCEL help feature to find out more
about it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Worksheet Lists 8
Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
Last Modified By in a cell by user 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
trying to use Indirect function 5
Daily Time Sheets with Rounding 1

Back
Top