Help with Formula

Good morning;

=IF($L3=600,””,INDEX(Activity!$L$2:$L$601,$L3,1))

The indexed cells referenced in my formula contain a Hyperlink. When the cell contents are indexed to a worksheet the Hyperlink text appears but the active link does not.  What needs to be added to the formula to activate the Hyperlink?

Any help would be greatly appreciated.  I apologize if the terminology is not correct, I’m not a programmer.

John

By: John

Leave a Reply

Your email address will not be published. Required fields are marked *