Here is the formula I am using

=IF(A1="","",VLOOKUP(A1,B:D,3,FALSE))

Column 3 is a list of names, and each of them is set up as a hyperlink to open to various file locations. Using the above formula I can get the folder name to show, but it removes the formating for the hyperlink location. Is there anyway to fix this?