how to hyperlink between cells
 

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

how to hyperlink between cells
 

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

"Jon" wrote:

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