Does a hyperlink index match work online?

[MissKiwi]

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.

[#2]

@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