MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combine the IF function with the HYPERLINK ??


Posted by Roar on September 01, 2000 3:13 AM

Hi
Does anyone know if it's possible to combine the IF function with the HYPERLINK function in excel.
Say cell A1 contains a name and B1 contains a hyperlink to a sheet with the name in A1, then if you change the name in cell A1,is if possible to have the hyperlink automatic change to a sheet with the new name.

Thanks


Posted by Tim Francis-Wright on September 01, 0100 9:05 AM

It should be possible to do this.
B1 could be =HYPERLINK("[c:\file.xls]"&A1&"!a1")

Change c:\file.xls to the appropriate file name.
The first A1 is the reference to the cell with
the name of the sheet. The second A1 sets the
target for the hyperlink to be cell A1 of the
new file.

HTH