Forum Discussion
Hyperlink and view the cell in different workbooks
Hi Experts, I'd like some help with this, i have 2 workbooks, namely Test 1 and Test 2 .. Excel file (Test 1) TEST 1 100 TEST 2 200 TEST 3 300 Excel file (Test 2) TEST A...
You can use HYPERLINK with MATCH.
If the value in Test 1 is in B2, and the matching values in Test 2 are in column B, try:
=IFERROR(HYPERLINK("[Test 2.xlsx]Sheet1!B"&MATCH(B2,'[Test 2.xlsx]Sheet1'!$B:$B,0),B2),"Not found")
Copy it down for the other values.
Clicking the result should open Test 2.xlsx and jump to the matching value in column B.
If the workbook is in a different folder, you may need to use the full file path.