Hi all,
I hope that someone can help me with this..

1. I have long list of URL addresses that I want to have displayed on a random basis. I only have space for 5 at a time
2. In column A of sheet 1, I manually input the URL addresses on a regular basis (these are news items so needs to be kept up to date)
3. In Column B I have entered =RAND() for all cells that have a corresponding URL address
4. On Sheet 2 (main display sheet) I want to display the random list of 5 URL's. I have used :
=HYPERLINK(INDEX('Data Breach'!$A$1:$A$6,RANK('Data Breach'!B1,'Data Breach'!B1:B6)))

5. This works fine, but it displays the URL address which is to long for the cell in Sheet 2
6. I want to use a 'friendly name' for each of the the URL's that has a hyperlink to the URL, so the user can double click the cell in sheet 2 when displayed and get take to the relevant address
7. I know I can do this with a normal hyperlink as I already have a link for specific reports that has a friendly name assigned:
=IFERROR(HYPERLINK(INDIRECT("'collateral'!C"&SMALL(Collateral!A:A,1)),"Report 1"),"")

7. I've tried to embed the url into a friendly name (on sheet 1 column A) but when it shows on sheet 2 it says it 'cannot open specified file'. Had this problem before

8. Can some let me know if what I am after is possible

Thanks

Grinfactor