Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |