Greeting,
I have a list of employees Names and IDs. All IDs are linked to another
sheet that it has courses of employees. I am using the following formula and
it works grate. What is happen if linked happen , it takes me to the first
cell of employee ID that is matched and other IDs also shown. What I want to
do if link happened, only the employee ID shown in Sheet of Course only,
other IDs of employees to be hidden. How to do that?
This is the formula that I am using:
=HYPERLINK("#"&CELL("address",INDIRECT("'"& E4 &"'!c4")),D4)