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.