HYPERLINK + INDEX/MATCH problem (Excel Windows vs. Online)

[RonOliver]

Hi!

I've got this formula.

=HYPERLINK("#"&CELL("address",INDEX(M3A!$C$10:$C$368,MATCH(X19+1,M3A!$C$10:$C$368,1))),X19+1)

The formula works in my workbook as follows: this is a part of the formula that is located in a calendar that I made, which links to a cell in a diary in another sheet (M3A). That way, this cell will link to the cell that displays the same date in sheet M3A: it finds the date displayed in the cell on the M3A sheet and links to that specific cell. This is all great in Excel for Windows, but it doesn't work in Excel Online. Can you give me a different way of writing this formula which is compatible with Excel Online? Thanks!

 

[Fluff]

How about

=HYPERLINK("#"&ADDRESS(MATCH(X19+1,M3A!$C$10:$C$368,1)+9,3,,,"M3A"),X19+1)

 

[RonOliver]

Apparently, this actually works. I'll test it thoroughly in the next few days. Thank you so very much! You've helped me a lot lately.

 

[Fluff]

You're welcome & thanks for the feedback.