=HYPERLINK("#A"&MATCH(B2,A:A,0),"clickme")


"John" wrote:

In Column A, I have 2 years of dates from A2: A732, with the function
"Match" I can locate the cell reference of a specific date but I would like
to be able to go to that cell directly if its possible. I know the function
"Go To" will take me there but am looking for something like a Hyperlink. Is
it possible?
Regards
John