| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hyperlinking
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinking when it shouldn't... | Excel Worksheet Functions | |||
| Automated Hyperlinking | Excel Worksheet Functions | |||
| Hyperlinking Excel on Intranet | Excel Discussion (Misc queries) | |||
| Hyperlinking footnotes - urgent question | Excel Discussion (Misc queries) | |||
Threaded Mode
