Getting a Hyperlink to work through lookup / index

Hey how is everyone doin today. New here been trying to figure out how to get this to work but I have no luck. I am attempting to utilize an automated lookup table to display information as long as a hyperlink. I have gotten it to where if you select the item you are looking for it will display the information you need to know about it, but when I have it look up the cell that is on a different sheet that has a hyperlink attached it will not open the link. I have gotten it to send you to the cell that the link is in on that page, but I do not want people to be able to visit this sheet and mess with it, or select the wrong link on accident. I have tried to use these two different strings to attempt this. =IFERROR(HYPERLINK("#"&CELL("address",INDEX('Master List (2)'!$C$11:$C$152,MATCH($C13,'Master List (2)'!$B$11:$B$152,0))),"PDF"),"") this one allowed me to go to the cell based off matching the material spec number. I tried going the basic vlookup method and it just gives me the cannot open file error =HYPERLINK(VLOOKUP(C14,'Master List (2)'!$B$11:$C$152,2,0)). See attached image the highlighted yellow field is the selection list, the information below is what is pulled up based off that selection. I am trying to allow my sales / purchasing team to be able to open this file up by searching up what they need and have the hyperlinked pdf work off of this populated list. The original hyperlinked PDF is on page labeled Master List (2).