Index and Match Function wont pull cells hyperlinks

I have a "Master data" sheet on sheet 2 of a workbook. On sheet 1, I have two drop-downs to select sections of the data sheet and Index-Match functions to display information based on which two selections were made in the drop-downs. The issue I'm having is that in my master data sheet, one of the columns contains cells that are hyperlinked to pdf's. When I use the Index-Match function to pull that cells information on to sheet 1, the hyperlink isn't pulled as well.

The index match function I'm using is below:

=INDEX(Sheet2!E2:E1375,MATCH(Sheet1!E5&Sheet1!D8,Sheet2!A2:A1375&Sheet2!B2:B1375,0))

Any help would be great!

Thanks.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Gum.

I'm interested in the solution you found to your problem. I am having the same problem with the hyperlinks not pulling through to a different sheet.

I am wondering if you would be so kind as to explain your solution in more detail to me, particularly this part:

"This has been solved by placing the hyperlink next to the data on the master data sheet. The hyperlink function on Sheet 1 uses an Index-Match function to locate the link and a second Index-Match function to pull the name as the link name.

I am using multiple search criteria and my formula looks like this: =HYPERLINK(INDEX(Table1[Link to Client Contact Tracker],MATCH(1,('Client LookUp'!$D$6=Table1[Last Name])*('Client LookUp'!$D$5=Table1[First Name]),0)),"click to jump")

I get the message: "Cannot open the specified file".