I'm guessing something like this may work for you:

Where A1 contains a name and A2 contains a hyperlink to a location in
the same workbook, but displays the Job Title.

Example:
The current workbook is: MyWorkbook.xls
The employee name is: Joe Boss
His Title is Dept Manager (which displays in the cell)
The job description is located on Sheet1 in Cell A5

A1: Joe Boss
A2: =HYPERLINK("[MyWorkbook.xls]Sheet1!A5","Dept Manager")

Clicking on A2 brings you to Sheet1!A5

Note: you can have the HYPERLINK function's arguments refer to othe
cells, instead of typing in the values.

Is that something you can work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=518911