Use VLOOKUP to Create a Hyperlink to Another Excel Worksheet
Question details
The user wants to create a clickable link to another worksheet using a VLOOKUP result.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A lookup table contains information used to identify a destination in another worksheet.
- Observed behavior
- VLOOKUP returns a cell's underlying value but does not preserve its hyperlink object or formatting.
Check that the lookup value is in the first column of the lookup range and that the return column contains either a valid link destination or a worksheet name. Confirm the destination worksheet and cell reference exist.
Wrap VLOOKUP in HYPERLINK to Create the Worksheet Link
Use this method when the lookup column contains a complete destination address or a worksheet name from which you can construct one.
VLOOKUP does not retrieve the address stored in a cell's hyperlink metadata. The lookup must return the destination as text, or enough information to build it.
In column B of the 'Key Word Search Terms' worksheet, enter a destination such as #'September'!E56 as text. Keep the matching lookup key in column A.
Select the cell where you want the link and enter =HYPERLINK(VLOOKUP(L2,'Key Word Search Terms'!$A$3:$E$28,2,FALSE),"Click Here"). Replace L2 and the lookup range with your own references.
Click Click Here in the formula cell and verify that Excel opens the intended worksheet and cell. If VLOOKUP returns #N/A, check that the value in L2 matches a key in the first column of the range.

Create VLOOKUP Worksheet Links in WPS Spreadsheets
In WPS Spreadsheets, combine VLOOKUP and HYPERLINK to turn a stored worksheet destination into a clickable link.
- 1. Open the workbook: Open WPS Spreadsheets and select Open to load the workbook containing your lookup table.
- 2. Check the destination column: In the lookup table, enter a destination such as #'September'!E56 as text in the return column, next to its lookup key.
- 3. Add the formula: Select the output cell and enter =HYPERLINK(VLOOKUP(L2,'Key Word Search Terms'!$A$3:$E$28,2,FALSE),"Click Here"), adjusting the references to match your workbook.
- 4. Test and save: Click the resulting link to check the destination, then select Save to keep the formula in your workbook.

Frequently Asked Questions
Why doesn't VLOOKUP return the original clickable hyperlink?
VLOOKUP returns the cell value, not its hyperlink object or address metadata. Store the destination as text in the lookup table and pass it to HYPERLINK.
What address should I use for a link to another sheet in the same workbook?
Use a destination beginning with #, followed by the sheet name and cell reference. For example, #'September'!E56 points to cell E56 on the September sheet.
Can I link to a sheet if VLOOKUP returns only its name?
Yes. Combine the returned sheet name with #, quotes and a cell reference inside HYPERLINK. For example, use =HYPERLINK("#'"&SUBSTITUTE(VLOOKUP(L2,'Key Word Search Terms'!$A$3:$E$28,2,FALSE),"'","''")&"'!A1","Click Here").
What should I check if the formula returns #N/A?
Check that the value in L2 exists in the first column of the VLOOKUP range and that the range includes the matching row. FALSE requires an exact match.




