Can VLOOKUP pull in cells that contain hyperlinks?

I am trying to use VLOOKUP to pull in cells from another table. Those cells contain hyperlinks. When I try it I get only the text and not the Hyperlink.

I tried just Link Cell and that worked but I do not want to manually have to link every individual cell. I want to lookup the title and return the cell with the hyperlinked information.

Best Answer