Forum Discussion

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(D4...

excel

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