Index Match Open Hyperlink

I need to perform an index match function. The result of this function will be in column C and will contain a live hyperlink to a different file.

Once I perform the index match I need it to find the result in column C and open the file. I've tried a number of things but can't get this to work.