Move to the result of the address function

[Wigglebritches]

I have a formula "=ADDRESS(MATCH(EnterDate!$B$1,MTD!$A$1:$A$33,0),2,4,1)"
I get the result which depends on the date entered in B1, but I need to actually move to that cell automatically.
What can I add to this formula that will move me to the resulting cell?

[benishiryo]

hi Wigglebritches. welcome to the forum. try:
=HYPERLINK("#"&ADDRESS(MATCH(EnterDate!$B$1,MTD!$A$1:$A$33,0),2,4,1,"MTD"),"Link")

if not, upload a sample excel file & we can see

[Wigglebritches]

This worked. How does the formula change if placed in a macro?