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.