Forum Discussion
Excel formula - cell index match - but want answer to be direct cell reference
Hi, I have a day planner where in excel you click the date and you are taken to that days day planner (in a separate sheet). The formula I have used uses cell index and match and so searches for...
I've managed to get the cell address, using a helper column
The answer displays as: '[Sample - Sunday Start Daily Digital Planner.xlsx]Part Two - day planners'!$A$2
This is the correct cell. But I am struggling to create a hyperlink to this cell. As I'll have 365 formulas, I don't with to use command +K.
I've tried the hyperlink formula, but maybe my syntax isn't quite right. I can't get it to link to the cell address that has been generated.
The answer displays as: '[Sample - Sunday Start Daily Digital Planner.xlsx]Part Two - day planners'!$A$2
This is the correct cell. But I am struggling to create a hyperlink to this cell. As I'll have 365 formulas, I don't with to use command +K.
I've tried the hyperlink formula, but maybe my syntax isn't quite right. I can't get it to link to the cell address that has been generated.