Hyperlink not working from Vlookup

[Jamber89]

Hello Everyone,

I have created a search page in a work book to look up parts. When a part is typed in a row of information shows up. within that information one cell is supposed to be a hyperlink to the actual parts drawings. However, because I'm using vlookup to pull the information from the other sheet the hyperlink in not an actual hyperlink its just text. Does anyone know of a way the keep the hyperlink intact. I have attached a sample of the document I'm working on.

Vlookup-Hyperlink Test.xlsx


Thanks,
Amber

[gmr4evr1]

I think you need the IFERROR in that formula as well. The odd thing, in the sample you posted, the hyperlink is shown correctly in O22 of the search page.

[Jamber89]

I did try that first and still wouldn't work. I don't know what to do or try.

[gmr4evr1]

Did you see the 2nd part of my post? I downloaded your sample file and the hyperlink is shown correctly in O22 of the search sheet. It is clickable and shows the path to the file and everything.

[FDibbins]

Try this instead...
=IF(C22="","",HYPERLINK("#"&"'MasterList'!C"&MATCH(C22,MasterList!C:C,0),C22))

Although your cell is showing as a H/L, the H/L is not working