Hyperlink and view the cell in different workbooks

You can’t make the original number cell clickable while it references itself – that would cause a circular error.

Instead, keep your numbers in column B and use a helper column for the hyperlinks.

In Test 1.xlsx, put this formula in cell C2 (next to your first number) and copy it down:

=IFERROR(HYPERLINK("'[Test 2.xlsx]Sheet1'!B" & MATCH(B2, '[Test 2.xlsx]Sheet1'!$B:$B, 0), B2), "Not found")

Clicking the number in column C will open Test 2.xlsx and jump to the matching value in column B.
If the files are in a different folder, use the full path with single quotes:

=IFERROR(HYPERLINK("'" & "C:\YourFolder\[Test 2.xlsx]Sheet1'!B" & MATCH(B2, 'C:\YourFolder\[Test 2.xlsx]Sheet1'!$B:$B, 0), B2), "Not found")

Just be sure to replace C:\YourFolder\ with the actual folder location.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.