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?


--
Niccalo
------------------------------------------------------------------------
Niccalo's Profile: http://www.excelforum.com/member.php...fo&userid=4344
View this thread: http://www.excelforum.com/showthread...hreadid=375191