how to hyperlink between cells

J

Jon

Greeting,
I have employees sheet and it has basic info for each employee, ID,
Name…..etc. and I have another sheet that shows employees courses. What I
want to do is how to hyperlink between the employee ID and his courses in
sheet 2 ? Note that I have more than 200 employee and more than3000 courses
 
E

Eduardo

Hi Jon,
try a vlookup by ID #, let's say in sheet 1 you have employees information
and in sheet 2 courses, I assume that employee names are in column A1 and ID
in B, in sheet 2 Column A1 has as well employee names
=+VLOOKUP(A2,Sheet1!A:B,2,FALSE) if will give you the ID required
 

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

How to filter list if hyperlink happen 8
how to compare two sheets with repeating rows 1
can a drop down list be set up to enable multiple selections? 1
Reference a cell on another sheet and have the information auto up 2
Compare difference between 2 worksheets 2003 1
URGENT HELP: Establishing a Training Matrix 6
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Excel VBA - counting cells by colors and names to it in two different rows. 0

Top