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

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

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

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

Is there anyone who may be able to help?

Thank you in advance for your consideration and understanding.