G0 to cell reference
 

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

G0 to cell reference
 

With your reference date in, say, D1, put this in E1:

=IF(D1="","",HYPERLINK("#A"&MATCH(D1,A2:A732,0),", jump"))

Just click on the word "jump" to move directly to the appropriate cell
in column A.

Hope this helps.

Pete


On Aug 27, 1:19*pm, "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

G0 to cell reference
 

Actually, because your data starts in A2 and MATCH returns the
relative position, you will have to add 1 to get to the correct cell,
i.e.:

=IF(D1="","",HYPERLINK("#A"&MATCH(D1,A2:A732,0)+1, ",jump"))

Hope this helps.

Pete

On Aug 27, 1:31*pm, Pete_UK wrote:
With your reference date in, say, D1, put this in E1:

=IF(D1="","",HYPERLINK("#A"&MATCH(D1,A2:A732,0),", jump"))

Just click on the word "jump" to move directly to the appropriate cell
in column A.

Hope this helps.

Pete

On Aug 27, 1:19*pm, "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- Hide quoted text -

- Show quoted text -

G0 to cell reference
 

Thank you Pete
It works great
Have a nice day
John
"Pete_UK" wrote in message
...
Actually, because your data starts in A2 and MATCH returns the
relative position, you will have to add 1 to get to the correct cell,
i.e.:

=IF(D1="","",HYPERLINK("#A"&MATCH(D1,A2:A732,0)+1, ",jump"))

Hope this helps.

Pete

On Aug 27, 1:31 pm, Pete_UK wrote:
With your reference date in, say, D1, put this in E1:

=IF(D1="","",HYPERLINK("#A"&MATCH(D1,A2:A732,0),", jump"))

Just click on the word "jump" to move directly to the appropriate cell
in column A.

Hope this helps.

Pete

On Aug 27, 1:19 pm, "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- Hide quoted text -

- Show quoted text -

G0 to cell reference
 

=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

G0 to cell reference
 

You're welcome, John - thanks for feeding back.

Pete

On Aug 27, 1:43*pm, "John" wrote:
Thank you Pete
It works great
Have a nice day
John

G0 to cell reference
 

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