Thank you Teethless mama
I got it working.
Regards
John
"Teethless mama" wrote in message
...
=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