Hyperlink to cell by matching a value in another worksheet

[JimCog14]

Hello everyone,

New to the forum, I've been reading a lot of the posts to avoid resubmitting questions and have learned a lot in the process. So thank you! But now I have a question that I need help with.

I'm trying to create a hyperlink that directs me to the cell in Column A of Sheet2 that matches an exact value from Column A on Sheet1. After much research, I've come up with the following formula:

=HYPERLINK("[AE Job Tracking.xlsx]April Notes!"&ADDRESS(MATCH(A6,'April Notes'!A6:A120,0),1,1,,"April Notes"),"Go to")

When I click the hyperlink that was created, it returns a message that says "Reference is not valid." I literally copied the value between the two sheets to identify the matches more easily in a test run, but the link doesn't work.

Is this an error in my formula? If so, can you please help me correct it? Thank you in advance!

[DBY]

Hello
You seem to be referencing the worksheet twice. You only need to reference the sheet once. For example this goes to cell A6 on Sheet1 in the current workbook:

Please Login or Register  to view this content.

Hope this helps.
DBY

[JimCog14]

Thank you so much, that was so simple! I appreciate it.

[DBY]

Glad to have helped.

[Tony Valko]

this goes to cell A6 on Sheet1 in the current workbook:

=HYPERLINK("#"&ADDRESS(6,1,1,,"Sheet1"),"Go to")

Or, simply:

=HYPERLINK("#Sheet1!A6","Go to")