Search and Link across worksheets

[excelDuffer]

As my ID suggests, I am far from expert level in Excel, but I find tha
two days of Google have not helped narrow down a solution, nor have
found an appropriate link elsewhere.

I need to set up an find/match/hyperlink in a template worksheet. Eac
deployment of the template will contain different data, but th
sheet/cell references should remain consistent.

Here's the deal - I would like to be able to say "In T4 on Sheet1, rea
the value of C4 on Sheet1, and search Sheet2, Table18 and put a link t
the match (on Sheet2) in Sheet1, T4." (find Sheet1!C4 i
Sheet2!Table18, insert link to Sheet2!<result> in Sheet1!T4). Then, o
course, carry this down the list for rows 5-999 on the source table i
Sheet1. The basic idea is to allow the end users to click a link tha
will take them to another sheet with detailed data on the record tha
they are currently using.

I have been going this alone, trying match, index, hyperlink, vlooku
and combinations of the above. But I'm just not able to figure out th
right combination.

Is there anyone who may be able to help?

Thank you in advance for your consideration and understanding

 

[excelDuffer]

Dear *ExcelDuffer*, Good Afternoon.

Any chance you could show us an example of the workbook to make i
easier to understand the issue?

Attach it here.

Attaching a smaller version (.zip format was the only one I could get i
under the size limit). In this copy, I want to read Sheet1!C4, an
create a link in Sheet1!D4 that points to Sheet2!E7. Fill in th
pattern, etc.

Please let me know if this requires any clarification.

Thank

+-------------------------------------------------------------------
|Filename: Sample.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=374
+-------------------------------------------------------------------

 

[excelDuffer]

Attaching a smaller version (.zip format was the only one I could get i
under the size limit). In this copy, I want to read Sheet1!C4, an
create a link in Sheet1!D4 that points to Sheet2!E7. Fill in th
pattern, etc.

Please let me know if this requires any clarification.

Thanks

Anyone have any further thoughts on this? Can I provide additiona
information if it would help?

Thanks

+-------------------------------------------------------------------
+-------------------------------------------------------------------