Forum Discussion

MissKiwi's avatar
MissKiwi
Copper Contributor
Oct 08, 2021

Does a hyperlink index match work online?

Hi all

The formula's in my excel file work perfectly though the desktop, but if this formula will not work if online.  

=HYPERLINK("#"&CELL("address",INDEX(BigRockProspects[COMPANY NAME],MATCH(D414,BigRockProspects[COMPANY NAME],0))),"SEE PROGRESS REPORT")

 

BigRockProspects[COMPANY NAME] is the table name and column which is on another worksheet.

 

I get this annoying message below.  I have tried to use the worksheet name and column but nope didn't work.

Thanks in advance for your help.

 

 

excel

1 Reply

  • PedroWave's avatar
    PedroWave
    Brass Contributor
    Oct 10, 2021

    MissKiwi, a hyperlink index match works online if all tables are in the same workbook.

     

    BigRockProspects[COMPANY NAME] is on another worksheet or on another workbook?

     

    Please, attach your Excel file to try to help you.

     

    Regards,
    Pedro Wave

Resources