ExcelL Vlookup Function and Hyperlinks Results Error

Hello,

On my Excel Page, I have created a search engine.
The search engine is analyzing rows J1:J100 on the same worksheet.
Within the rows are hyperlinks that open up separate (worksheets) tabs within the workbook.

When I use vlookup, I want it to return the results.
Unfortunately, the results do not come back as hyperlinks.

Can anyone please help?

Thank you in advance.

use =HYPERLINK(... your vlookup formula here)

Hi Sadath,

I tried.

=IFERROR(HYPERLINK(VLOOKUP(A5,H2:J91,3,FALSE)),"")

However, the results still don't show.
Thanks.

Hi

try this =HYPERLINK(IFERROR(VLOOKUP(A5,H2:J91,3,FALSE),""))
or =HYPERLINK(VLOOKUP(A5,H2:J91,3,FALSE))

Hi Sadath,

With both, I get the error message - cannot open specified file. Although, the result does come up as a hyperlink. Thanks.

Richard